If you have all workbooks open you can use them in any cell references
by selecting the appropriate window and worksheet and cell. Excel will
take care of the file paths if you close the workbooks (the summary
workbook last)

Hans