=SUM('Sheet1:Sheet3'!A1)
will total cell A1 on Sheet1 through Sheet3. Some of the experts recommend
inserting a sheet named Start and one named End before and after the sheets
you want included in the 3d formula (for reference and you don't need to
modify your formula if you add/move/delete sheets.
