Combine contents of multiple workbooks into one worksheet

[EMG03]

I want to aggregate data from multiple workbooks into one. I have five
workbooks with identical columns and formats, and want to run a macro in a
separate workbook that copies all rows (starting with row#2 and ending at the
last row with data) from the five workbooks and pastes it all into the new
one. Or something like that. Thanks in advance.

[Anne Troy]

Try this?
http://vbaexpress.com/kb/getarticle.php?kb_id=773
************
Anne Troy
www.OfficeArticles.com

"EMG03" <[email protected]> wrote in message
news:[email protected]...
>I want to aggregate data from multiple workbooks into one. I have five
> workbooks with identical columns and formats, and want to run a macro in a
> separate workbook that copies all rows (starting with row#2 and ending at
> the
> last row with data) from the five workbooks and pastes it all into the new
> one. Or something like that. Thanks in advance.