Need Sugesstions for Replicative Formats

Dear Forum,

I am making a Format which will be Replicated for each Sales Personnel, in my Format
I am naming the WorkBook as follows:
Sachin T Nov CC Follow-Ups where the First 2 Words are the First Name and the First Letter of the Last Name.

Sachin T, Now in this WorkBook I need to always have a Sheet with the Name as CC Sachin T which should be linked with the WorkbookName.

Need two things, one is to Rename the SHeet immediately based on the First 2 Words of the File/WorkBook Name and only the Name the Sheet which has the Name as "CC"

Then there are other sheets which are connected to this Main Sheet which is the CC Sachin T--- Sachin would be working on same Prospects Data and there would be 3 responses that will be captured such as Site Visit , Interested and Not Interested..

These three responses form the three SHeets Site Visit , Interested and Not Interested..
Now what I need is to Replicate the Formats for one Sheet and the other Sheets get Immediately the same Format..

Whatever Sachin enters as a response in the main sheet CC Sachin T would be separated and will go in these 3 sheets seperately.

This mechanism works fine, now I just want to have it in such a way that if i make one format with one name and just Save As with Different names then all of the other things automatically happen that is changing the name and also if there are small VB Codes for each of these three sheets gets copied for the other 2 Sheets.

Regards
e4excel