Assuming that each sheet contains the 'Total' figure in cell A100, try...

=SUM(Sheet1:Sheet12!A100)

Hope this helps!

In article ,
"Fybo" wrote:

Hi,

I am compiling an annual report with 12 sheets (one per month) and a final
13th summary sheet.

Each of the 12 monthly sheets are identical and I want to add the totals for
each month and present it as an annual figure on the final sheet (sheet #13).

I cannot figure out how to get Excel to look at all my sheets and total
these on the final.

Can it be done? Can anyone help!!

Many thanks,

Fybo.