Copy worksheet, paste, and rename

[bcas77]

I want to have a worksheet be copied, pasted immediately after that tab, and then all of the succeeding ones in that group renamed.
I have worksheets that are labeled Section 1, Section 2, etc. up to 22 (but there could be more or less, it changes.) and then I have 4 worksheets after the Sections which I don't want renamed.

I have attached a testbook that should help!
Thanks in advance to anyone who helps me

[bcas77]

When I say renamed, I mean this. Lets say I want to put a sheet in between Section 2 and Section 3. I would want the new sheet to be named Section 3, Section 3 to be named section 4, and the sheets that aren't named Section X to remain the same.

[bcas77]

Does anyone have any ideas on this? I tried just recording a macro but it wouldn't apply to any case except that one.

[bcas77]

Is there anything else I need to supply for help?

[Norie]

Which worksheet do you want to copy?

[bcas77]

Basically what I want is to be able to paste a blank template that is used in the "Section" tabs. After that is placed wherever it has to end up, I want to rename all of the Sections so that their number corresponds to their placement in the Section section.
For example, in my Testbook I have Sections 1, 2, and 3. If I were to copy that template from Section 2 and then paste the tab in between Sections 2 & 3, that new tab would be Section 3, and Section 3 would become Section 4.

[bcas77]

Is what I'm wanting to do not possible?

[Norie]

You've not given enough information really.

For example what do you mean by 'wherever it has to end up'?

How are you determining where the worksheet ends up?

[bcas77]

These tabs may get rearranged based on the type of report that will be printed later, so I will need to rename the Sections to numerical order based on what order they are in before printing.

I guess what I'm hoping for is potentially two separate macros. One that will insert a worksheet with the sections template, and another that can rename the Sections worksheets to numerical order. I'm not sure how the first one would look, but the second one could probably use a string compare for the worksheet name, right?

[Norie]

Sorry it's still not clear where you want to insert the new worksheet.

At first I thought you wanted to insert it after all the other Section worksheets but then you seemed to want it to go between sheets among those sheets.

[bcas77]

Yes, just after the end of the Sections worksheets.

[bcas77]

Should I just do both of those macros separately?