automatically add sheets and link them to external workbook named
 

Hi--

I'd like to have a dynamic workbook which automatically makes worksheets
with the following criteria:

1. Each worksheet created based on all workbooks found in a certain folder
and named after that workbook.

2. Each worksheet is linked to a named range (identical name in all
workbooks) in the workbook it corresponds to and this starts at cell A1.

3. As more workbooks are added or deleted from the reference folder, the
consolidating workbook should add or delete the sheet tabs accordingly.

Does this sound doable to anyone?

automatically add sheets and link them to external workbook named
 

See Ron DeBruin's site on the topics of Copy/Paste/Merge examples at
http://www.rondebruin.nl/tips.htm

Mike F
"Invoice" wrote in message
...
Hi--

I'd like to have a dynamic workbook which automatically makes worksheets
with the following criteria:

1. Each worksheet created based on all workbooks found in a certain folder
and named after that workbook.

2. Each worksheet is linked to a named range (identical name in all
workbooks) in the workbook it corresponds to and this starts at cell A1.

3. As more workbooks are added or deleted from the reference folder, the
consolidating workbook should add or delete the sheet tabs accordingly.

Does this sound doable to anyone?