Copy Multiple Sheets and Rename at One Time

Good afternoon:

I am currently working on an excel program for our sales consultant evaluations. What I have are master sheets based on the month. Each sheet has formulas based on the previous months numbers for a 3 month sales average. I have everything set up with a userform so the managers only have to enter information and it will input into the correct sales consultant/month. The problem I have is if we have a new employee, I would like to have a form where the manager can input the new employees name and information and a macro will copy all the master sheets and rename them with the new employees name and the month ie...John Smith Jan, John Smith Feb..ect., so that it matches what I currently have done. I have a code that will copy all the master sheets at one time but I can't figure out how to rename the sheets all at one time, I have found a code that will do it one at a time, but I feel this will be to time consuming for the managers and a bit confusing for some :) Any help would be greatly appreciated.