Q:

Dynamic Hyperlink Function to create a link for going from one cell to another cell

In the below screenshot, you can see that I have the worksheet Name in A23 and cell address in B23.
Note: The Content of B23 is prepared by a Macro. So it is dynamic and might get changed every time.  However A23 (sheet Name) stays the same. 
How can I use the Hyperlink function by clicking on it  to go from the cell C23 to the cell in worksheet "BW2018" and cell A353 ?

A:

GO to the insert tab and select on the link button. When the window pops up click on the "Place in This Document" button. In the space where it says "Type the cell reference:", do just that and you can link to whatever cell you want. 
If you want to create a dynamic hyperlink then you can use the formula suggested by @m. salem.  =HYPERLINK(A2&B2&C2) Where A2 is the workbook name, B2 is the worksheet name and C2 is the cell that you want to link to.

