Looking for help merging 2 macros.

I have a bit of a complex issue.

I have this Macro created by Xero Solus:

Please Login or Register  to view this content.

I need to modify it a bit for the following issues:

1. The macro should check to see if a worksheet with the exact name already exists, and if so, do not re-create it.
2. As each sheet is created, run the following macro on the newly created page:

Please Login or Register  to view this content.

the 2nd macro is hobbled together code and I'm sure it looks like crap, but it functions. If someone could help me clean this up and merge it together I would greatly appreciate it.

Hmm... I'm getting a run time error 1004 'This option is unavailable for this type of external database." I realise that this is impossible for you to test on your side because you have no access to our database.

Here are my troubleshooting steps.

1. I tested this on a brand new workbook placing my list on column D of sheet 1
2. Running your new code created a new sheet for the first name on the list, placed the name in cell E1, then it produces the run time error with the debug highlighting this part of the code:

Please Login or Register  to view this content.

3. I copied my other macro in to this new workbook:

Please Login or Register  to view this content.

And this macro works just fine. It pulls the correct data from the external database with no error.

Is there maybe another way to go about this that I can try?

Thanks so much for your help.

unfortunately I'll have to wait until Mon morning to try these out. But thank you very much

The first of the 2 you posted worked perfectly. Thank you for your help!!!!