To see how to schedule events using VBA, go to: http://www.cpearson.com/excel/OnTime.aspx

You say:
Do you want a new workbook, new sheet in an existing workbook, or a new column in an existing worksheet? Is there more than one buyer per week? Is there a reason all buyer data can't be output to different (or even the same) worksheets in a common workbook? Either way, you're going to have to construct your own query to extract the data in a format that you can use to (a) populate the workbook(s) and (b) analyse.

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