In the Template, (soon to be the new Project Sheet,) Code page
Option Explicit
Private Sub Worksheet_Activate()
'Because ProjectName will be erased when Excel Closes
If Me.Name <> "Template" And ProjectName = "" Then ProjectName = Me.Name
End Sub
Sub Button_Click
Sheets("Total").Activate
End Sub
In a Module
Option Explicit
Public ProjectName As String
On the Totals Code page
Option Explicit
Sub Button_Click()
If ProjectName <> "" Then
Sheets(ProjectName).Activate
Else: MsgBox "You must Activate the Project sheet once before this will work"
End If
End Sub
In the Sub that copies the Template to a new sheet
'Set the value of the Public Variable
ProjectName = InputBox("Select Name of Project")
Sheets("Template").Copy Name = ProjectName
All that is just one way to keep the last activated sheet in memory. This version is just for one specific sheet, the one named "ProjectName"