How can I create a dynamic link to another excel file? I want the user to type in a name in cell A1 and in cell B1 it is linked to the file name typed in A1 and reads a cell value in that file. Can this be done through a function such as =[name.xls]Sheet1!C20 where "name" is what was typed in cell A1?