Conor Sweeney was the hero for Tipperary in Cavan as they mounted a late fightback to reach their first All-Ireland quarter-final.