Consolidate multiple workbooks into a single worksheet

I have 20 workbooks and the main worksheet in each has the same layout. I
need to consolidate the inforamtion provided in these workbooks into a single
worksheet.

The data hosted in these files consist of text and numbers.

I need to consolidate this information weekly.

Hi Krista

Have a look here:
http://www.rondebruin.nl/copy3.htm

Hope this helps.
Andy.

"Krista" <[email protected]> wrote in message
news:[email protected]...
>I have 20 workbooks and the main worksheet in each has the same layout. I
> need to consolidate the inforamtion provided in these workbooks into a
> single
> worksheet.
>
> The data hosted in these files consist of text and numbers.
>
> I need to consolidate this information weekly.
>
>