Hi, I have the following code which works perfectly to merge all excel files in a specified folder into 1 file with multiple tabs:

HTML Code: 
The worksheets that were merged above only contained 1 tab but I now have a scenario where I would like to merge files with multiple tabs.

However, I only want to merge worksheet 2 from each workbook into 1 large workbook with lots of worksheet 2's as separate tabs.

Does anybody know if there is a way that I can modify my code so that I can specify which worksheet I would like to extract?

Thanks very much in advance

:-)
:-)