Sorry about the previous reply. What looked like a passable formatting in the preview got horribly changed in the posted version.



Let me try again. Hope this image version stays intact.



No, the picture is no more than a generic icon.

Sorry for cluttering up the space.

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...

Attached Files

	collector.xlsx (10.9 KB, 11 views)
	source.xlsx (13.8 KB, 12 views)