Combining multiple workbook info

[Moogie]

Thanks in advance for any help. I have multiple Excel Workbooks (same directory). I need to send the info from the first sheet (Sheet1) in each of these Workbooks to a single sheet in a new Workbook. I know how to copy the sheets and I have a macro to merge once the sheets are copied. But I would like to have a macro that would just merge the sheets without copying first.

 

[just_jon]

Merge the sheets how?

 

[Moogie]

I would like to copy the data on Sheet 1 from all of the workbooks and concatenate it onto one worksheet of a new workbook.

 

[just_jon]

Just the next sheet1 below whatever's there, you mean?

 

[Moogie]

that's correct. The info that is copied to the new workbook can all be on sheet one, just below each other is fine.