Just wondering about this -

I have sheets that are monthly ones which, at this moment, only started up
since I began to learn more about Excel, last month. I dragged my March
stuff from the Word doc I have it in to Excel, tidied it a bit and auto
summed the totals at the bottom. All well. April was done as the work was
done and auto sum totals and again all OK. Started into May and thought that
I would prefer Year to Date totals to auto update as I entered new data and
came across Consolidate and started a YTD sheet just for those totals. This
works well enough as I specified a particular cell for each of the totals I
am interested in and moved the totals of each sheet, to the same cell on
each monthly sheet and then consolidated the 3 sheets. So, at the moment my
YTD sheet actually DOES do what I want but the formula to consolidate
mentions ONLY those months March to May 2007 and nothing else. When I start
June I have to go back and add, into the consolidate formula, the June total
and the same for every other month of the year.

What I would like to do - as I am likely to forget to update consolidate -
is to set a formula in YTD sheet that would see, say "July 2007" sheet total
and all other months as I create them without me having to go back and
update the consolidate formula. So, if I decided to drag across Feb 2007
from Word to Excel the totals for that month would auto update the YTD
sheet. I actually WILL be going back in time and getting the data across
soon and this would help if that were possible.

So, does anyone know if it can be done? I believe the command to react in
the same way in both Excel 2003 and 2007 but if it makes any difference, I
use the 2007 version. Thanks.