Multiple files to one workbook

[raja_puligadda]

Dear all,

1. I've 5 files in a folder + 1 blank file
2. Each file has 2 worksheets.
3. Each sheet has different data, hence number of rows & columns vary.
4. I want to transfer the 1st sheet of each files in to the Blank file as separate sheets.
5. I am a Novice, So please mention any path changes & cell references need to make in the macro.

6. I've few questions : What if Number of files in the folder change ?, What if i have more number of sheets in each file ?

Hope i am clear about the requirement ..
Thanks in advance

[raja_puligadda]

Anybody please

[raja_puligadda]

Hello guys.. Do we have a solution for this ??