Jeff,

Take a look he

http://www.rondebruin.nl/copy3.htm

hth,

Doug

"JEFF" wrote in message
...
Hi All,

I'd like to be able to go to each workbook in a folder and copy the same
data range from each and paste into a consolidated workbook. For example,
go
to each workbook in Folder X, copy the contents in Sheet1 (range A1:A3),
and
paste into Consolidated.xls..... This implies that the contents copied
from
workbook A would go into row 1, the contents from workbook B would go into
row 2, and so on....

Any help would be greatly appreciated!