I need to copy cells from a number of closed workbooks into a separate workbook. I was hoping to create an Excel formula to do that. On each row of the target worksheet, all the information comes from the same cells (E27, F27, H27, H46, E13, F13 & H13) on the source workbooks -- but each row needs to access a different workbook. The workbooks are all similarly named with the exception of a code prefix. The code prefix can be found in column B of each row on the target worksheet. For example, all source file names are something like "xxx - Source Data" where xxx is in each populated row in column B. Is there a way I can use a cell value in the path/file name to retrieve the data from a closed workbook? Or do I have to create a macro to do this. I believe the Indirect function will only work when all workbooks are open.