If the Totals are in the same cell on all sheets just enter

=SUM(Sheet1:Sheet52!F34) on any sheet in any cell.

If sheet names are not standard.....................

Set up a worksheet sandwich.

First you have a Summary sheet.

Then a blank sheet named Start.

Then a couple of your weekly sheets.

Last have a blank sheet named End

In Summary sheet enter this formula =SUM(Start:End!F34)

As you add sheets insert them between Start and End so's they get picked
up by the formula on Summary sheet.


Gord Dibben MS Excel MVP




On Wed, 30 Jan 2008 14:12:02 -0800, john wrote:

example I would like to bring totals from all 52 weeks sheets into a total
worksheet .

week 1, week 2 etc into total work sheets