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?

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

Mike F
"Invoice" <(E-Mail Removed)> wrote in message
news:F56053D9-FD2B-4C19-8A4A-(E-Mail Removed)...
> 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?