excel linking collating data into one workbook

[k]

Hi I want to know how to link specific cell references of various files
residing in different folders in a location onto a new workbook.
can someone help by providing a simple solution of just specifying the
file name in a particular cell of a new workbook and linking up the
specified cells that exist across various files residing in different
folders in a location by way of a formula?

 

[Doug Robbins - Word MVP]

This is really an Excel question. But I believe that in the new workbook,
you just use = and then select the cell in the other workbook.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP