Use the VBA code name of the sheet so you will always be dealing with the same sheet no matter what the current tab name is.
Code:
Dim DestSh As String
DestSh = "The_New_Name"
With Sheet1 '<~~~~ the sheet's code name
.UsedRange.ClearContents
.Name = DestSh
End With