I am trying to enter a formula in my master file to copy data from a single cell in a closed workbook. The formula also has a reference to the file number I am trying to pull the data from. This is so that, as the number of files increase, the formula will automatically generate the necessary info and I don't have to open the file each time I need to update the original.

I have used this reference method in a hyperlink to open the complete file and all works well.

The formula I am trying to get to work is:- =INDIRECT.EXT("I:\browns invoices\["&N502&" Invoice]\Invoice!D8"). The reference &N502& refers to the invoice number listed in the master sheet.

I would prefer to keep all the invoices and relative files stored in "I", but if this is a problem they can be moved and stored on the main drive "C".