VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs

Hi Experts
I am using the Ron de Bruin macro which merges multiple workbooks saved in a particular folder into one single workbook. The issue with this macro is that it extracts only one sheet/tab from the workbooks and merged them into one single workbook in different tab. I want to macro which pulls the data from different tabs if they are available as well in the final workbook.
Example in case if a workbook consists of more than one tab, these tabs data should also added or included in the final workbook
Regards,
JD

Post the code you are using.

Hi John

Please find the code below:

Main Code

Please Login or Register  to view this content.

Sub Procedure

Please Login or Register  to view this content.

Hi John

Please find the entire code:

Please Login or Register  to view this content.

Hi John

I am getting error while uploading the entire code.

Please find the macro attached.

Regards,
JD

Hi John

Any view on the above thread.

Regards,
JD

See if this helps?

Hi John

Perfect! It is working as well my expectation.

Thanks a lot!

Regards,
JD

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.

Hi John

I already marked it Solved, but I dunno why it is not reflecting in the main heading. If you check the sub-heading just above the main heading you will see the solved icon - [SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs.

I see it now. Thanks.