I attached an XLS file with a sample how to dynamically create a hyperlink to the cell on the second sheet. Surely one solution among others.
In column D of the first sheet, a formula searches the address of the cell in the second sheet by comparing the PID's. In column E, the filename and sheet name of the second sheet are retrieved by using the formula Cell(). And in column E the two results are putted together for creating the hyperlink.
Hope this helps.