Using Variable Worksheets
 

Here is my present pickle with Excel.

I have been asked to create a worksheet that will be emailed in once a
week. A Master worksheet will read the data off the individual
worksheets and display all the data on one page. Further, the Master
worksheet will need to be able to compare this data with the data from
the prior week. All this needs to be done with little to no actual
work done by the person looking over the Master worksheet.

The individual sheets will look much like this:

John Doe July 5, 2004
July Aug Sept
$300 $250 $123

$1000 $750 $300

The master sheet will look much like this:
July August Sept
6/28 7/5 6/28 7/5 6/28 7/5
John Doe $200 $300 $100 $250 $0 $123
Jane Plain $200 $345 $400 $200 $10 $0

John Doe $900 $1000 $500 $750 $40 $300
Jane Plain

Any ideas or insights that might help would be greatly appreciated.