Solved: need to copy data from one workbook to another on selected cells

[zebradoby]

Hi
Just to clarify, In the attached zip file:
Test1---Will store the macro
Test2---Source File (may or may not be multiple source files)
Test3---Destination template (number of destination files shall be same as source files)