Hi All,

I know this is going to be fairly simple task for any of you who knows VBA well. But I am almost bad in that.

I have multiple excel files in a single folder(Source and destination in the same folder). About 10 individual files and one Master file . I have to copy the data from the sheet1 of all the individual files and paste them to the master. Each time I run the Macro, the Master tracker Sheet1 should be cleaned and pasted with the fresh data except the headers in Row1.

Data should be copied from A2 of all the individual files as the Master will already have the headers and should be appended and no need to check the duplicates. The individual files are updated on the daily basis and I need to consolidate them as well daily. You can use Column A as the reference as there wont be any breaks in the same. The data is in A:N. I use 2007 version of MS Excel.

Please let me know if you would like to have any additional information. I thank you in advance for your help !

Regards
Sreeram