This will get you close to what you want on Ron DeBruin's site..
http://www.rondebruin.nl/tips.htm

Check out the Copy/Paste/Merge examples. From what I remember on these
examples are that the source workbook is in a different folder than the
target workbooks. Perhaps you will find something here that fits, or you
could temporarily move the source book long enough to make the copy, then
put it back with the others.

Mike F
"Jerome" wrote in message
...
Hi there,

Could you please tell me how to paste from a single workbook to multiple
workbooks in the same folder. I need to copy 5 columns to the same sheet
on
all the multiple workbooks. I need to copy it after column AN. I am new to
programming. Thank you in this regard.

Have a good day further.

Jerome