I have been trying to create some specific features in an existing workbook since last week. Here is an outline of what I need:

Create a new page while maintaining the formatting (so basically copy and Move to end)
Launch a dialogue box to prompt to rename the new sheet
Associate with a button

Now, I can create these features independently but not all together. I can't seem to pinpoint in the VBA how to merge them.

Also, I don't know if this is even possible, but my employer would like the button that does all of the above to appear on the new page that is being created.

Help!