Pasting a Name on a Tab through a Macro

[squeakums]

I can't seem to figure out how to paste a name onto a tab in vba. In regular excel I can use use the ctrl and v option. But, how would you write to paste a copied name on a tab through a macro?

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/21/2009 by test
'

'
Windows("Test's Team (Individual Monthly).xls").Activate
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(1)
Windows("Test's Team (By Group).xls").Activate
Sheets("Monthly Logged Details").Select
Range("A2").Select
Selection.Copy
Windows("Test's Team (Individual Monthly).xls").Activate
ActiveSheet.Paste
Sheets("Template (2)").Select
Sheets("Template (2)").Pastevalues
Range("A1:N1").Select
Windows("Macro.xls").Activate
Range("A1").Select
End Sub

 

[Weaver]

Maybe

Sheets("Template (2)").name = "whatever new name"

 

[squeakums]

That will name the tab - whatever new name. I would like for it to paste a name that I copied. How would I do that?