I am using Excel 2003. I have created a workbook with multiple sheets for tracking data on a weekly basis. Each sheet is the same, same rows, same headings, just different data coming in (tracking sales, hours, etc). The workbook is being used by a manager that is not familiar with Excel. I have created it so all she needs to do is copy/paste a new worksheet for each new weeks data.

What I want to figure out is how to create a summary sheet at the beginning of the workbook that will automatically update the data that is currently populated, but will also update new data that is added when she creates a new worksheet.

I am not an expert with excel, and have yet to use any VBA solution (in fact, I just today learned that term, if, indeed I am using it correctly). If there is a better way to do what I am doing, I'm very open to suggestions.

The reason I used this set up for my manager is that it also includes graphs for each week, so she can "see" the data better. The copy/move worksheet works great for creating a brand new worksheet with the graphs I put into them, so when she populates the data, she can see the results immediately.