Hello, 
I want to refer to a cell in another workbook and I need to use a string value from a cell in the current workbook as part of the name of the Workbook that I want to refer to (so that I can use "Data Validation - List" to quickly change the input. I know it can be done by using INDIRECT, but the problem for that method is that the referred Workbook has to be opened, which is not convenient.
For example a formula looks like this, but I want to repalce "WB1" by a cell value from a drop-down list in a cell.
=[WB1_Summary.xlsx]Sheet1!$A$1
I wonder if there is another way to realize this function. Of course VBA will always work but usign VBA is not a good solution in this case since the data is large and messy.
Thank you all very much!

I want to refer to a cell in another workbook and I need to use a string value from a cell in the current workbook as part of the name of the Workbook that I want to refer to (so that I can use "Data Validation - List" to quickly change the input. I know it can be done by using INDIRECT, but the problem for that method is that the referred Workbook has to be opened, which is not convenient.
For example a formula looks like this, but I want to repalce "WB1" by a cell value from a drop-down list in a cell.
=[WB1_Summary.xlsx]Sheet1!$A$1
I wonder if there is another way to realize this function. Of course VBA will always work but usign VBA is not a good solution in this case since the data is large and messy.
Thank you all very much!