dynamic workbook

[younathan]

hey guys...

just wondering if anyone knows how I can create a "formula" o
something similar that gets the sum from the same location (i.e. A4
from every worksheet.

For example, every day of the month has its own worksheet, and there'
an extra work sheet that sums the total. I am looking for a way to ad
all the worksheets as I create them because initially I start off with
sheets (day 1 and month's total). Daily, I add a new sheet, so by th
8th day, I have 9 sheets total.

So, is there anyway I can have the last sheet (month's total
dynamically change its formula as I add a new worksheet?

Thanks in advanced

 

[Bob Phillips]

Add a worksheet that will always be at the end, just as a dummy, say "Last",
and use

=SUM(First:Last!A1)

 

[Tom Ogilvy]

Put in two extra blank sheets. Name one Start, name one Finish

Now in the summary sheet put in a formula

=Sum(Start:Finish!A4)

insert your daily sheets between start (at the front) and finish at the end.
Put your summary shout outside of these two boundary sheet.