I entered the following formula:

=CONCATENATE("Creates function, ",HYPERLINK(ProjectTrackingDB_Queries!A2),"
which allows the GetSQL query to return the SQL statement of a given query.")

which yields the text string one would expect it to yield. However, when I
click the hyperlink I get an error, "Cannot open the specified file."

Cell A2, which is referenced in the formula above has the text "GetSQL".

Any ideas as to what I'm doing wrong?