I have successfully used the following to create a dynamic link:

=HYPERLINK(INDIRECT("'" & $A$12 & "'" & "!" & "A2"))

The problem is that if there is no value in the cell referenced for
the dynamic link, it returns that annoying #ref!
So, I thought I would be smart, and change it to:

=IF(A12="","",HYPERLINK(INDIRECT("'" & $A$12 & "'" & "!" & "A2")))

This got of the #ref!, sure enough, but now, gives an error and says
that the reference is invalid.

Thoughts?