Hyperlink to a cell containing a reference

I work in accounting and the dinosaurs above me prefer that I insert hyperlinks to where I pull numbers from rather than use Ctrl+[ to navigate to cell references. My problem is that I want to write a formula that can generate a hyperlink without having to manually enter the tab and cell that a number is pulling from. For example, if a cell on a calculation tab (let's call it 'Calc Tab') in cell C10 is pulling a number such as $10,000 from Cell P8 a balance sheet tab (let's call it 'Balance Sheet 1'), I want to write a formula in cell B10 on the calc tab that can pull the reference from C10 and take me directly to cell P8 on the balance sheet tab. I could do this manually, but I work with a ton of workbooks each and every day and I am looking for a more efficient formula to write that I could hypothetically copy and paste each time. I have been messing with the hyperlink formula with a nested indirect function, but haven't been able to crack it. Thanks for the help!

Here is a revision that is copy-and-pastable.

Formula:

=HYPERLINK("[hyperlink.xlsx]"&SUBSTITUTE(CELL("address",Sheet2!A1),"$",""),Sheet2!A1)

OK so I tried that code, however, I don't think it solved my problem. Here's a simplified example of what I need:

Cell B2 on Tab A contains the number 10,000
Cell C3 on Tab B contains the formula "=TabA!B2"
*This info is all in the same workbook so I don't think the workbook reference in brackets is necessary*

I want to write a Hyperlink formula in Cell B3 on Tab B that creates a hyperlink to the location of the item referenced in cell C3 (i.e. to the 10,000 on Tab A), but I want it to pull the info from Cell C3 and not manually input a hyperlink to B2 on Tab A. If that makes sense. Thanks again!

Sorry, on re-read of you original post I see you described exactly what you wanted and I missed that you had the formula in one cell and the link in another.

You have to use VBA to do this. See attached, with UDF in Module1.

Worked like a charm. Thanks!