Changing External Reference in formula automatically?

[mmille10]

Is it possible to change the external reference of the file ='[DDR RAP FINAL 2017.xlsx]Dashboard'!$C$61.

I have ID Codes in Column A. All my files are formatted by "ID Code" & RAP FINAL 2017.xlsx and i need the same cell location pulled from each file.

How is it possible to change DDR to the next ID code below? EG A1 DDR A2 LLR I will need ='[LLR RAP FINAL 2017.xlsx]Dashboard'!$C$61 and not want to manually change it.

 

[JonXL]

Is it possible to change the external reference of the file ='[DDR RAP FINAL 2017.xlsx]Dashboard'!$C$61.

I have ID Codes in Column A. All my files are formatted by "ID Code" & RAP FINAL 2017.xlsx and i need the same cell location pulled from each file.

How is it possible to change DDR to the next ID code below? EG A1 DDR A2 LLR I will need ='[LLR RAP FINAL 2017.xlsx]Dashboard'!$C$61 and not want to manually change it.

Use INDIRECT.

=INDIRECT("'["&A1&" RAP FINAL 2017.xlsx]Dashboard'!$C$61")

 

[mmille10]

Use INDIRECT.

=INDIRECT("'["&A1&" RAP FINAL 2017.xlsx]Dashboard'!$C$61")

This formula only works if the documents is open. I want it to work if they are closed and in the same file.

Thanks