Finding worksheets based on master workbook worksheets and copying to master

[bigwig88]

Hi guys,

Apologies for my lack of VBA skills but I'm having difficulty finding code to do the below.

Basically I need a macro to copy and paste worksheets based on sheetnames from the master.

For example I have the following:

Master Spreadsheet with 5 worksheets named
A
B
C
D
E


I want to find worksheets A,B,C,D,E in a source worksbook which conatains hundreds of worksheets.

So I need the macro to loop through the source workbook find the worksheets named in the master and copy it into the master worksheet with the same name.

Thanks in advance for any help!

 

[bigwig88]

Hi,

Or even finding worksheet based on cell values and copying the sheet to a new master sheet? Does anyone have any ideas?

Thanks,