Formula for reading data out of several files

Hello

I am trying to create a link that is changed in relation to my combo box. I can get so far as to define the file name incorporating the outcome, however excel will not take this into a file path.

Please bear with me as i am not the most experienced in either posting or excel.

I have attached the file. Please see for example the link in cell D5, I wish for excel to use cell I2 in the path name so that the link is changed corresponding to the combo box.

It seems that this may not be possible and the only work around I know of would require the target file to be open on the PC. I wish to avoid this as eventually the file will be quite large and it would be quicker simply to manually update links.

Any help or solutions would be much appreciated.