Copying various worksheets to new Worksheets upon selection via drop down lists.

[skyping]

Need your help once again!!!

A previous project needs to be updated and I simply cannot my head around it.

I have a workbook (please see attached) that currently comprises of 5 worksheets, 3 of which are relating to my problem and are hidden. These are called Link1, Link2, and Link3. To unhide these demo sheets please run the macro UnhideAll when opening the workbook, but are intended to be permanently hidden.
The initial concept of the project was to generate new worksheets labelled from the contents of c12:c31 on the Intro worksheet. This works fine…. see macro labelled Generate (can be run via the button marked accordingly).

However, I have added another variable which is displayed in a drop down list in j12:j31, which relates to the content of these 3 new hidden sheets.

What I need to do is when generating the new sheets via the Generate macro, the corresponding selection in column J, will copy the relevant sheet (Link1, Link2, Link3 or nothing) to the new sheet with the corresponding name from column C.

Listed below is the macro in question:

Please Login or Register  to view this content.

I really hope this is coherent (!!) and welcome any advice on this problem, and / or my code…please be kind, I am still learning!!!

Many thanks for looking.

Skyping

[skyping]

Any ideas anyone?

[arlu1201]

What is the issue you are facing with your code?