I've 2 macros in 2 different files... which basically does the following:-
1)allowing user to select what files that they want to select.
2)combine the contents for an opened workbook into 1 sheet.

Prob:After the user has selected the files,all the excel files will be opened.Each excel file can contain >2 worksheets.
Ie) If i opened 2 workbooks & each workbook contains 2 worksheets,how do i combine them into 1 worksheet?

Thanks a million

hi miracles.

When you open each workbook, each will have a Sheets() collection which allows you to access individual sheets within the workbook.

Are all the sheets the same format/location etc?

Regards,
Rob