My problem is that hyperlink will not allow you to use the absolute function
(ex. $B$12) like in =$A$2+$B$4. So that where ever you drag the numbers to a
different location the location of cell changes and not the value.

Problem in detail...
I have a workbook with sheets 1, and 2
In sheet 1, I have a hyperlink defined to go to [Sheet 2 in Cell B3].
In sheet 2, I have numbers 1-10 in Column B respectively in order.

However if I were to move the value in Cell B3 to Cell D9 the hyperlink will
not follow to the new location. So if I were to click on the link in sheet 1
it will take me to [Sheet 2 in Cell B3] and NOT [Sheet 2 in Cell D9].

Essentially I want the link to follow the value placed in that cell.

Thank you