Formulas for Multiple Worksheets
Hold down the Ctrl +` keys at the same time to display a formula
Look at the Formula =SUM(Chicago!B7+‘Atlanta s'!B7+Boston'!B7)
The ! Means that the formula spans across worksheets.
Formulas may also span across workbooks using the same method, However all of the workbooks must be open