The workflow, with a separate sheet for each week, makes this unnecessarily difficult. Given that a single Excel worksheet can handle 1,048,576 rows, there is no good reason all the data can't go onto one sheet from where extraction would be a simple task. On top of that, you're trying to use Excel as both a database and a database report generator, a task for which Access is much better suited. With all the data on a single Excel sheet, though, report generation via mailmerge would be a reasonable alternative.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]