Navigating sheets together

Hi!

I have one excel workbook with 3 spreadsheets, in which the left column represents a day of the current year, going from row 2 to 366/367 in the three sheets.

Is there a way to make all 3 sheets navigate together? i.e., if I am on March 3rd in the first sheet on March 3rd, all other sheets will be positioned in March 3rd when I go to them (preferentially keeping the column they were).

Thanks in advance!

Done!

I don't know if it's the cleanest way, but works:

Put this in the workbook vba code

Public Last_Selected_Row As Long

Private Sub Workbook_Open()
   Last_Selected_Row = 1
End Sub

And this for each worksheet

Private Sub Worksheet_Activate()
  ActiveSheet.Cells(ActiveWorkbook.Last_Selected_Row, Selection.Column).Select
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  ActiveWorkbook.Last_Selected_Row = Target.Row
End Sub