Hi guys

I am new to the forum and have been searching around to see if I could figure this out but can't. Any help would be greatly appreciated.

I have a file that is pulling one value from a field in a closed file. Link below:

='W:\Client\C\Client name\2013\Test File\Test Name\filedname\List\[filename.xls]test'!$H$60

What I am trying to do is replace the \fieldname\ with a cell from the sheet so it will dynamically pull a new value when that field is updated.

So if G7 has the link ='W:\Client\C\Client name\2013\Test File\Test Name\TEST1\List\[filename.xls]test'!$H$60 and in the same sheet if B2 has the value TEST1, when I change B2 to TEST5 that the link changes to ='W:\Client\C\Client name\2013\Test File\Test Name\TEST5\List\[filename.xls]test'!$H$60