why do you need a macro for that...
Looks like a simple task, you can create a collector workbook, connected to the monthly workbook, as the samples atached. When you have a new workbook with data, just use a copy of the collector workbook with changing the data source (Data-edit links-change source-and browse to where your new data is located-select file-ok)
if your task is more complicated, you have to give more details...
|