Hi,

If I understand your problem it still shouldn't be a problem. The process could work both ways. Every month update the individual workbooks (with a macro) with any changes, and then grab the data back again as described before.

Regards