I'm trying to pull into one sheet, the values from the same 10 cells in
about 500 spreadsheets all stored in the same way.

Using =CONCATENATE() I can construct the formula which correctly
reference each cell in each file (all date named files), also using the
=TEXT() function to create all the file names. However I still need to
f2 then f9 each formula produced by the =CONCATENATE() function to get
the cell value pulled through from the relevant file. I don't want to
have to do this 5000 times, is there a shortcut that anyone knows?



--
shfcook
------------------------------------------------------------------------
shfcook's Profile: http://www.excelforum.com/member.php...o&userid=27169
View this thread: http://www.excelforum.com/showthread...hreadid=466779