use macros to copy and paste from 1 file to several files
 

Hi, i have a file that i regularly work on for data to be pasted to several
files. In the data, it contains part of the filenames of the files that each
set of data needs to be pasted to.

As an example, i have data called "Master file". in one of the worksheet,
lines 1 to 100 needs to be copied and inserted into line 3 of File A, line
102 to 200 needs to be copied and inserted into line 3 of File B. At the
same time, File A and B needs to be created and name "File A" and "File B" .
I have to do this to about 10 files several times a month.

Please let me know if you have a good automated solution for this. Thank you.