Hello Guys,
I'm facing an issue and i will be grateful if you can give me a hand.

I have an excel sheet that will be reading values from specific cells from other excel workbooks, the thing is that i need the file name (in the formula) to be variable, to make more sense please notice the below reference

='C:\Users\John\Desktop\Evaluation\Eval\[1876-192013.xlsx]Sheet1'!H37

I need this part (1876-192013.xlsx) to be variable according to the values of cells in the same sheet (somethimg like C6&"-"&D9), so it will fetch the data from the corresponding excel files with the same title. How can i do this? preferably without VB.

your help is highly appreciated,
Thank you,