There's a quicker way to tally up figures that are on different Excel sheets than manually typing out a formula with the sheet names, exclamation points, cell references and plus signs in the formula bar.
Click on the cell where you want the cumulative data to go, then type =…