Linking Worksheets in an undefined number of Workbooks

O

ozcarb

I am trying to link worksheets in different workbooks to sum values.
The problem is that the number of workbooks varies and the workboo
names change. The result is to be a summary workbook.
How do I: 1) define the workbooks in a summary workbook and 2) use tha
information to define the cells in the various workbook worksheets t
sum them
 
Top