Consolidate Multiple Worksheets

Hello all,

After reviewing the forum I have found code that I can modify to consolidate sheets within a given folder, although it will select all Excel files.

I have also located code that can multi-select worksheets and open them. I just need to merge the two but do not know how.

I'd like to select multiple worksheets in a dialog box (GetOpenFileName), etc, then consolidate them to my "Consolidated" worksheet in the active workbook.

The code I found is as follows:

Open multiple files:

Please Login or Register  to view this content.

Consolidate sheets in a given directory:

Please Login or Register  to view this content.

Where am I to start on this one?

Thank you for your help!

Does anyone know another way to combine the two codes?