Calculate Year-to-Date total in from multiple sheets

[TMA]

This should be simple, unfortunately so am I...

I need to calculate a running year-to-date total on a project containg 52 (one for each week) worksheets. I know how to write the formula by going to each sheet and referencing the one before, but is there a way to write it so I don't have to do it on each sheet? Each sheet has about 30 rows so doing it by the sheet takes a great deal of time.

I have attached an example. Please help.

[davesexcel]

Try grouping the sheets then Writing the formula just once
This link explains how to group sheets
http://office.microsoft.com/en-us/ex...024921033.aspx
Be sure to ungroup sheets after you have finished

[TMA]

Thanks for the reply, but I'm still doing something wrong. When I group the sheets and put in the formula, it sums each page but does not do a running year to date total.
_______________________________________________________
I figured out what I was doing wrong, thanks.