Pulling Data from another cell; Linking to a cell macor

[imogul]

Hi, I'm writing a macro that will pull a data from different reports. Normally I would just link the cells but the cells I need change. I have a formula that I can use the value from as a relative reference to tell me what cell the data is in, but I don't know how to add the link in VBA. I'm thinking something like this (ignoring the relative refernce part for now) :

Hyperlinks.Add Anchor:=.Range("A5"), _
Address:="u:\[Test Page, New report creation.xlsx]", _
SubAddress=range("A5")

but that doesn't work. Basically I need to know the code to link a cell from my active sheet to a another sheet that I know the name and location of.

Thanks!