Hi Krista

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

Hope this helps.
Andy.

"Krista" wrote in message
...
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.