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