how to depend on the equation to make a two-way linkage?

I‘m a new learner about VBA ，recently I have a problem in Excel and I searched and asked some people online ,but eventually don't have an answer .So I start to ask for help here and hope someone could help me on the VBA question.

My questions is :

for example : in sheet1, there is an equation " = sheet2!F4" in the B2 of Sheet1,(in fact the B row is full of the equation like this and the B row is the collect from the other sheet ) so I want to use the VBA to make the hyperlink like this :
1： the B2 is linked to sheet2!F4, so when I click the B2, it turn to the sheet2!F4
2 the reverse hyperlink ： the sheet2!F4 is linked to the B2 when I click the sheet2!F4, it turn to the B2 of the sheet1

the other blank is B3=sheet5!G7 B4=sheet9!K6 and so on , so there is no rules in the right side of the equation

so in short:how to depend on the equation to make a two-way linkage, the B row is hundreds of the equations like this . So if you're a convenient time，could you think about the VBA code to make it possible ? Thanks.