Vba connect sheets with a button

Hello i am new here and i would like a help!
i have 3sheets: a calculator , job ticket and a quote
the only input data is on calculator the other two are autofilled with the nessasary data i need from calculator
i need to create a button in the calculator and when it clicked to automate dublicate the current calculator so i can calculate a new piece but i want to add the same time new specs of the work on the other templates!

Well i created the button i need, now i want when i create a new sheet of my template to automatically copy paste the yellow range of cells on the other two sheets and connected with my new template!
and this to be continued for every new template i create !

Option Explicit

Private Sub CommandButton1_Click()
Dim ans As String
    ans = Me.TextBox1.Value
    Sheets("Template").Copy After:=Sheets(Sheets.Count)
    ActiveSheet.Name = ans
    Me.TextBox1.Value = ""
    Sheets(ans).Range("A1:K8").Value = Sheet2.Range("A6:K13").Value
    Sheets(ans).Range("A10:K18").Value = Sheet3.Range("A6:K13").Value
    Unload UserForm1
End Sub