+ 0 Votes Here's one way.... indirect() gs-techrepublic 6 years ago G'day,You can point to a value in another workbook by using a formula like:='[Summary.xls]Sheet1'!A1This is saying that you want cell A1 of sheet Sheet1 in workbook Summary.xlsTo make this dynamic, let's assume you have the name of the file (without the .xls) in cell K9: "Summary"You can use the indirect function to build up the reference. Basically, indirect takes in a text string, and converts it into a reference.=INDIRECT("'[Summary.xls]Sheet1'!A1") is the same as the previous formula. Now, you just need to make the workbook name variable:=INDIRECT("'["&K9&".xls]Sheet1'!A1")this will go to the workbook with the name of whatever is in K9 and look at cell A1 of Sheet1. The & sign in the formula means concatenate - it joins the string '[ with the value in K9 and the remaininder of the string .xls...Hope this helps. + 0 Votes Indirect to reference worksheets JimAvanti 6 years ago I did try Indirect in the past as you stated and couldn't get it to work (Just tried it again). Maybe my version of excel? Even before I get to the workbook variable in a cell it won't work.Works: ='[FC93409063470062.xls]Sensor Configuration'!$C$25Won't work: =INDIRECT("'[FC93409063470062.xls]Sensor Configuration'!$C$25") This isn't something I NEED to get working anymore (I made a VB script that fills in all the links for me automatically), but it would be nice to know how to get it working with a formula. + 0 Votes Indirect to reference worksheets benickerson 6 years ago As Jim described, I have a need to dynamically build a filename in Excel for data retieval. I have not yet found a solution.I also found that INDIRECT does not work for this purpose. I have not been able to get any function to with concatonation for a filename.