Copy paste data from a Master file to Multiple Reports

Hi All,

I am pushed against a challenge wherein I need some help!

I’ve searched the net thoroughly, but haven’t found a solution that caters to my requirement. There are several Macros to Copy data from multiple excel files to single master file. I use some of them too. However, need some sort of Macro to accomplish a task wherein I spend close to 8-hours daily.

What I am looking for is your kind help in being able to do with a Macro:

• Populate row data from specific columns from a “Master File” to a bunch of customer specific reports placed in a folder on a daily basis.
• Master File has the data for all the clients in our universe
• There are 300-500 client specific reports in a folder. I need to be able to pull the data for each of them from the “Master File”
• Column A will have the customer file name against each row
• Column B will have the tab name

I am currently working on the sample files to facilitate better explanation of my request, which I can provide early tomorrow, but thought it best to seek some guidance if this is doable. I haven’t found anything on the net as such. However, there are ample solutions to consolidate data into one sheet.

Request your expertise. Please advise your thoughts…

Regards,
Spi