How to share data from one file to multiple files

[prabhuduraraj09]

Hi all,

I wanted to transfer Data from Master file to other multiple files.

Details :

I have master file with sheets A, B, C, D, E etc., In each of a sheets i have names listed along with number of tasks assigned.

I have files in same names, with same sheet names A, B, C, D ,E etc.,

Attached sample Master file and files for two names "Antony" and "Patric"

if i execute the macro in master file, it should open each of the files like "Antony", "Patric" etc., all the file that is available in the specific path folder
If the file name "Antony" is opened, then Data relevant to Antony from master file needs to be copy pasted in Antony file. The data should be transfered to relevant sheets From A to A, B to B etc., and save close.

Like wise, whatever the file is available in specific folder the data needs to be copy pasted from master file to relevant file.

could someone help me on this please.

Attached sample file.