I want to have a worksheet automatically be populated with the name and several bits of data from other workbooks in a particular folder.

I can get the names to be entered using the INDEX function but currently need to manually edit the path statements to get the extra bits of data.

I cant use the INDIRECT function as the files are closed... and it seems that I cant use INDIRECT.EXT as I am using Excel 2013 64 bit.

Any suggestions ?


Many Thanks

Andrew