I am trying to create a final data spread sheet that is automatically filled
in from a raw data page, where the raw data is imported from a dicoverer
query. below is an example of my data.

Raw Data: Sheet 1 - Cells A5:E13
Shop TSD 1-May-09 4-May-09 5-May-09
04 PCKE
04 PJK3
04 Shop Total
18 BOKB 1.00 1.00 2.00
18 Shop Total 1.00 1.00 2.00
19 JMMX 2.13 1.00
19 Shop Total 2.13 1.00
24 JTKT 1.00 1.00 1.00

This sheet will only have data for certain days.
---------------------------
Final Data: Sheet 2: cells A3:I15
Shop TSD 1-May Subtotal AVE 5/1 2-May 3-May 4-May
04 PCKE C4 0.00 #DIV/0!
04 PJK3 0.00 #DIV/0!
04 Shop Total 0.00 #DIV/0!
18 BOKB 0.00 #DIV/0!
18 Shop Total 0.00 #DIV/0!
19 JMMX 0.00 #DIV/0!
19 Shop Total 0.00 #DIV/0!
24 JTKT 0.00 #DIV/0!
24 Shop Total 0.00 #DIV/0!
30 PCKJ 0.00 #DIV/0!
30 PJK1 0.00 #DIV/0!
30 PJKM 0.00 #DIV/0!

Sheet 2 subtotals and Averages are formulas I alreday have input. This sheet
will show everyday with a week designated as Saturday thru Friday. What I
need to do is populate the columns that have dates for the column headers
with the appropriate data from the raw data sheet. Example would be C4 would
be replaced by data based on Fnal Data: Column A & B (04PCKE) and cell C3
(date) being looked up on the raw data sheet for the matching Column A & B
and the correct date.

Any help with this would be greatly appreciated