I have about 60 separate Excel workbooks in similar formats, each of which has one worksheet with a unique list. I need to create a master list by accumulating all of those separate lists on a single worksheet in a separate workbook.
The workbooks will need to be linked so that the new master list is automatically updated when one of the separate lists is updated -- and be flexible enough to add data from new lists as they are created.
For what it's worth, all of the workbooks are in the same directory, the worksheet containing the unique list always has the same name, always uses columns A through R, but can be from 15 to 250 rows.
I know I can copy/paste special/link once for each of these worksheets - but I hope there's an easier way.
Any thoughts would be most appreciated.
The workbooks will need to be linked so that the new master list is automatically updated when one of the separate lists is updated -- and be flexible enough to add data from new lists as they are created.
For what it's worth, all of the workbooks are in the same directory, the worksheet containing the unique list always has the same name, always uses columns A through R, but can be from 15 to 250 rows.
I know I can copy/paste special/link once for each of these worksheets - but I hope there's an easier way.
Any thoughts would be most appreciated.