bodhisattva

Hey Kant,

You need to use the Indirect function to accomplish this; so there you would do:

Cell A1 = "ExcelFileName"

Cell B1 =INDIRECT("'"&"FilePath"&"["&$A$1&"]"&"TabName'!"&"Cell On Tab")


Now let me give you a real world example from one of my files:

Cell E35 = "Cost_Measures_08.11.xls"

Cell E36 = INDIRECT("'"&"C:\Users\453256\Desktop\NCR\"&"["&$E$35&"]"&"CM_Audits'!"&"C10")


Therefore, cell E36 will return the value of what is in cell C10 in the cost_measures file; if you change cell E35 to another file name that is in that folder, cell E36's value will be changed; hopefully this explains it.