Your code must be reactivating the original sheet, otherwise it would
automatically end up on the sheet whose tab was clicked.
Here's a bit of code residing in the sheet1 module that places the
clicked sheet's name in a string variable (strClickedSht), throws up a
MsgBox with the clicked sheet's name, reactivates Sheet1, selects A1 on
Sheet1 then activates the Sheet whose tab was clicked.

Private Sub Worksheet_Deactivate()
Dim strClickedSht As String
strClickedSht = ActiveSheet.Name
MsgBox ActiveSheet.Name
Sheet1.Activate
Sheet1.Range("A1").Select
Application.EnableEvents = False
Worksheets(strClickedSht).Activate
Application.EnableEvents = True
End Sub

Ken Johnson