code to copy and rename 2 Worksheets at same time and maintain formulas

hi

here are the codes i can get this to work separately with

Copy without renaming nut maintain grouped status

Please Login or Register  to view this content.

And

Copy and Rename but maintain formulas to template worksheet

Please Login or Register  to view this content.

Any help would be greatly apreciated

Craig