switch to same sheet same cell in different workbook

hello friends ,

i have two different workbook ..
workbook 1 = formula.xlsx
workbook 2 = hyperlink.xlsx

name of sheets in both workbooks are same
sheet 1 = 5055
sheet 2 = 5560

now , is it possible if i am in cell b3 in worksheet 5055 of formula workbook ,
and when i switch to hyperlink.xlsx , i am in automatically or already in b3 cell of worksheet 5055 of hyperlink workbook.

formula.xlsx is main workbook , where main data is stored and studied

for sample file i have attach two files with smaller data and only two sheets ,

but actual data and number of sheets are more....

yes hyperlink is good option ,

but my formula workbook has already hyperlink to another workbook

i am getting data to my formula workbook from another workbook ,

but as a sample file , i dint attach file in that manner .....

sorry sir ,
but i am new to vba ....

can you help me in detail , how to proceed ?

can anybody help me how to use below code for two different workbooks ,
which is my original question .


In a standard module, include the single line:

Public addy As String

In the Sheet1 code area, include the following event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
addy = ActiveCell.Address
End Sub

In both the Sheet2 and Sheet3 code areas, include the following event macro:

Private Sub Worksheet_Activate()
If addy <> "" Then
Range(addy).Select
End If
End Sub