I have several workbooks that I need to pull data from and place it in to a
single workbook. The data is identified by a logical cell, after it is
identified I need to move just 5 specific cells to the new workbook. Each
workbook has a unique name and is stored in it's own folder on a network
drive.

Any help would be apperciated.

Thanks

Well you can't move them.
but a copy, by simply having

='C:\My Documents\[Book5.xls]Sheet1'!$A$2

edt as required

Steve


On Mon, 01 Jan 2007 20:40:00 -0000, Mike C <Mike
wrote:

I have several workbooks that I need to pull data from and place it in
to a
single workbook. The data is identified by a logical cell, after it is
identified I need to move just 5 specific cells to the new workbook.
Each
workbook has a unique name and is stored in it's own folder on a network
drive.

Any help would be apperciated.

Thanks