Put in a blank page names end and a blank page name start (start should
precede End in the tab order.

In the summary sheet put in formulas like

=Sum('Start:End'!B9) in cell B9 for example.

you can then copy this across and down your summary sheet.

Now, move your exsiting sheets between start and end in the tab orded.
Import new sheet and move them between start and end as well. (move out old
sheets as appropriate).

--
Regards,
Tom Ogilvy


"Hambone" wrote in message
...
Hi,

I am running a macro that grabs 7 days worth of data and totals parts made
for those 7 days. I have a new sheet appear for each day and name it by
date. This works great; however, i am now trying to get all these totals to
apear on a one page report for the boss man. Seeing how 7 new pages appear
everytime this is run and are named differently each time how can i grab
this data?

Thank you,

Tom