Hi

One way you could do this would be to create two extra blank sheets in
your Workbook.
Rename them as First and Last.

On your Summary sheet, in cell B2 enter
=SUM(First:Last!B2)
(I am assuming row 1 contains headings and Column 1 contains headings)
Copy the formula across for as many columns and rows as you have in each
of your Monthly sheets

Now, drag the sheets to the following order (click on sheet tab and hold
left mouse button down as you drag to a new position, then release mouse
button)

Summary, First, March, April, May, Last

As you add more sheets, ensure that they are within the "sandwich" of
First and last and they will be summed.
If you wanted to see totals for a 3 month period, move First and Last so
they only encompass those three sheets.

Now, having established the principle of First and Last, I would
actually called them F and L to make their Tabs smaller, and change the
formula to
=SUM(F:L!B2)
Use colour for the F and L tabs so you can easily see what your summary
is including.

--
Regards

Roger Govier


"Diamontina Cocktail" wrote in message
...
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.