There is a bit of a trick to doing that. I assume that your day sheets are
all placed together in the workbook (they need to be for this to work). Add a
sheet just before and a sheet just after your day sheets (lets call them
Start and End). Now add a formula to sum (or otherwise aggregate) all of the
cells across the sheets including the blank sheet at the beginning and the
end of the days sheets. To do this in your totals sheet type "=Sum(" and then
select all of the sheets from Start to End by holding down the shift key and
then add the closing bracket. The formula will look like this...

=SUM(Start:End!A1)

Now just hide the sheets start and end. Now if you add another days sheet
(next to any of your existing days sheets it will be between the hiddend
sheets start and end and will therefore be calculated... I am not sure that
is the greatest expanation so if you need more assistance let me know...

--
HTH...

Jim Thomlinson


"Lisa" wrote:

I have a job project spreadsheet that has worksheets for days 1-4 and a
worksheet for the totals of all days. I need to add a day 5 worksheet, once
I add the worksheet how can I make the totals worksheet realize I added
another day and automatically pick up that info without having to go in and
redo the formulas on the totals sheet. I hope this makes sense.

Lisa