Copy sheet, rename with name and month increment

I have a series of worksheets named “Test Jan 16”, “Test Feb 16” through to “Test Dec 16” there is also one named “Test Template 16”

What I want to do is copy - insert and rename the “Test Template 16” sheet so I have a series of new sheets named “Test Jan 17”, “Test Feb 17” through to “Test Dec 17”. Ideally would like also if one does already exist, a Msg to say so but be able to continue with the others.
Want to place them in sequence after the “Test Dec 16” sheet (which will not be the last sheet – maybe the 4 or 5 to last sheet)

Brilliant that will do exactly what I was wanting.

But (isn’t there always) is it possible reference the last sheet of 2016 being “Test Dec 16” increase the 16 by 1 and then use that in the formatting of the new sheet name.

Simply trying to avoid having to remember every year to change the Templates year suffix 16 to 17, 17 to 18 and so on (no big deal) but also have to go to the macro and change the

Please Login or Register  to view this content.

It is a minor point but just wondered if it’s possible

As a side question what is the relevance of the reference to “A1” in the evaluate part?

If a sheet already exists with a name of the intended series (Jan – Dec) Msg dialog informs you as wanted and goes on and creates the rest. Only snag is the sheets will not be in month order, grant you there are not many times it will happen or sheets to just manually reorder but can it be done after inserting new sheets. Beginning to wonder if I am making this way over complicated!!

Well what can I say other than FANTASTIC, does everything I wanted and with the cherry on the top.
You have helped me out yet again. Many thanks
I am just going to add a default message at the start to make it safe from fools like myself inadvertently adding new month sheets for the next 20 years due to the changes made to the index referencing