Tab Name Matches Cell

I found the below script on this forum for "How to get a tab name to match the data in cell C6". PROBLEM IS: for some reason, it is applying the Tab name to another worksheet instead of the selected worksheet into which I placed the code - it appears to be applying it to the First worksheet, instead of the selected worksheet. How do I tell it to apply the name to the worksheet in which I placed the code?

Private Sub Worksheet_Activate()
Sheets(1).Name = Range("C6").Value
End Sub