Copying data from multiple worksheets of Multiple files into master file

[RPM1979]

Hi Friends,

I have multiple excel files stored in a folder. In each of said excel file, there are various multiple worksheets with data.

I have a master file containing multiple worksheets. I need a macro so that for each of the worksheet in master file, the macro goes to a predefined excel file and then copies the specified worksheet data in the master file.

There are approx 30 worksheets in Master file and i need to repeat above process for each worksheet, since this being repetitive work i am looking for a macro to assist me.

Eg
Master File >> Worksheet A >> Data to be copied from File 1 worksheet A
Master File >> Worksheet B >> Data to be copied from File 1 Worksheet D
Master File >> Worksheet C >> Data to be copied from File 2 Worksheet B
Mater File >> Worksheet D >> Data to be copied from File 3 Worksheet A
and so on for approx 30 worksheets in Master Excel File

Also the above activity will be repeated each month, so can we also have prompt wherein User will select the folder where misc excel files and master excel file is stored.

Friends hoping for a solution which will assist in reducing my time on a regular manual activity

 

[RPM1979]

Dear Friends,

Please assist with any solution on my above post

 

[Derek Brown]

What are the "real" names of the worksheets?
Are they "Worksheet A" etc.? If so, can they be renamed?
What version of Excel is being used?

 

[RPM1979]

Hi Derek,

You may treat the worksheet names as Sample 1, Sample 2 and so on