Prevent Text Box from being copied to a new sheet .

Tried to replicate what you described but failed. Perhaps because I added a text box as a rectangle shape since the form control textbox icon in the Developer ribbon is greyed out on my Excel (don't know why). File attached.

I can copy the Sheet1 the way you describe (right-click, Move or Copy... etc., or add a sheet then select the entire Sheet1, copy and paste to the new sheet, or press right Alt key and drag sheet to the right and drop it.

Neither of these options copies the shape with the instructions but data and formulas do. Give it try and let me know.

I suspect that what Kidd_lp intended was to use the SheetActivate event, so you don't have to wait for a cell to be changed:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Dim txtBox As Shape
    If Sh.Name <> "Tab 7" Then '...or whatever the name of the template worksheet is
        For Each txtBox In Sh.Shapes
            If txtBox.Name = "TextBox1" Then    '...or whatever the nmae of the control is
                txtBox.Delete
            End If
        Next txtBox
    End If
End Sub

Not much more information is available in Microsoft documentation.

But I would be very concerned about sharing a macro-enabled workbook among employees.  Discuss the security concerns with your IT staff.

How about by using VBA:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Dim txtBox As Shape
    For Each txtBox In Sh.Shapes
        If txtBox.Name = "InstructionTextBox" Then
            txtBox.Delete
        End If
    Next txtBox
End Sub