how do i bring numbers from one work sheet to another

[john]

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

 

[Gord Dibben]

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