Copy data from excel files in a folder to the Master workbook. Each file must be copied at a specific named worksheet, in the master workbook.

[Sunnykumar]

Scenario - There are multiple excel files in a folder whose data needs to be copied to specific (Already named) sheets of a master workbook.

For example - there are 117 files in a folder and their data must be pasted in 117 worksheets of the master workbook. The worksheets of the master workbook are already named.

let's say,
1 of the source file named as "Data1.xlsx", Now this has to be pasted in a existing tab of the master workbook's sheet named "SalesData";
2nd source file named as Data2.xlsx, Now this has to be pasted in a existing tab of the master workbook's sheet named "Quota";
----------------- and so on ----------------- for all 117 files-------------------------there are 117 designated named sheets in master file-------------------

I hope I was able to explain my situation.

Please help, I had been trying to search in many forums including this one, I asked the question, which is still unswered -

VBA code to copy multiple excel files to existing (already named) sheets of a master workbook

Scenario - There are multiple excel files in a folder whose data needs to be copied to specific (Already named) sheets of a master workbook For example - there are 7 files in a folder and their must be pasted in 7 different existing sheets of the master workbook. let's say, 1 of the source...

www.mrexcel.com

Thanks in advance to all.

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to your original thread about this.