Combining worksheets

[BruceEdwards]

I need to combine daily reports into a weekly report.

The daily reports have headers in Row 1, and Totals in a row named TotalRow, which is 2 rows below the last data row.

So, what I need is some code to:

1. Delete the header and totals from the daily sheets. But I want to have them in the weekly report. I could put those in later.

2. combine the worksheets

3. save the worksheet with a name such as "WeekEnding (with a date based on the last day of the week, which is Friday, when these reports are done.)

Any help would be greatly appreciated.

Thanks to all