I want to create a worksheet from another worksheet(TR1) via a commandbutton in a worksheet. Im pretty sure I have that figured out. However TR1 has links and formulas to another worksheet(PmpSch). So my problem is each time I change information in PmpSch its going to change in every worksheet that I created from TR1.
Is there a way to lock a cell once the formula has been initiated once? That way when I change information in PmpSch it will only transfer that information to the new worksheet I created from TR1.
Also, I would like the tab name to increase numbers, so the next worksheet I create would say TR2 and so on.

And thank you Norie for this suggestion!!