Assume that your summary sheet is not contained within the "sandwich"
made up of the "first" sheet and "last" sheet, and that you want to
add every E5 cell from the sheets. Here's the formula you need in your
summary sheet:

=SUM(first:last!E5)

Change those names to suit your sheet names - if you have spaces in
the sheet names you will need to put apostrophes around them:

=SUM('first sheet:last sheet'!E5)

Hope this helps.

Pete

On Feb 17, 10:51*pm, Excel makes life easier <Excel makes life easier
@discussions.microsoft.com wrote:
I have a standard template for all tabs in one workbook (there are about 100
different tabs). What is the function to sum the same cells in each tab and
carry over to a summary leadsheet?

Would this be similar to running a report?

Thank you!