Hello Mflores81 and xpcman,
Apologies for intruding but I believe that, on reading the first post, the OP already has a main sheet which he/she would just like to treat as a template sheet and just copy. So I would say that the simplest method would be:-
- Right click on the main sheet tab.
- From the menu that appears select "Move or Copy".
- From the "Move or Copy" dialogue box that appears, tick the "Create a Copy" box.
- Click OK.
This will make an exact copy of the main sheet with all formulae intact. Just rename the new sheet to suit.
I hope that this helps.