I want to retrieve a cell value from a closed workbook but the name of the
workbook varies depending the information entered in the active sheet.

I used the concatenate function in cell B4 to identify the workbook name
based on the information entered. For example: Test_June.xls

In the product cell, I have =indirect(B4) but the function doesn't allow me
to enter the column ($L$1) where the data is in the Test_June workbook.
Please, help!