Adding a Hyperlink to a IF Formula ( with a twist )

Ok, I see where this may be confusing, I don't think I expalined exactly what I need.

Let's use the workbook I provided.

On Sheet 1 cell A4 it currently contains this formula: =IF(B4="","",CONCATENATE("CCR",LEFT("0000",4-LEN(ROW(A2)-1)),ROW(A2)-1))
The bold text is what I want to act as the hyper link.
Now, cell A4 will only populate if something is in cell B4, B4 uses this formula: =IF(Sheet2!B3 = ISBLANK(TRUE),"",Sheet2!B3)
Bold text is where the hyper link should point to.
So in conclusion, the hyperlink I require need to point cell A4 in Sheet 1 to cell B3 in sheet two, using the unique ID created by the IF formula.

I hope that clears it up.