Reference to external files

Hi there,

I'm currently working on an excel file where I will have to refer to quite a lot of external files. It is quite easy to type in the name of the external file manually, but as the number of files is high this could be tedious, so I'm looking for an other solution.
Let me explain: the document in wihich the references will be already contains the names of the external files.
For example, in D1 I want to refer to E1 of a file located at C:\Users\Myfolder\[filename], where [filename] is "what is written in A1"_"what is written in B1".xlsx
in D2, I want to refer to E1 of "A2"_"B2".xlsx, and so on.
Is it possible to set that up somehow?

thanks for your advices!

Hi! Yes, I already found this function when looking for a solution on the internet. The fact that is requires the files to be open is not really practical, but I may try to put all the files in the same folder. Opening them should not be necessary anymore then.

Thank you!