Here goes,
I have spent quite a bit of time trying to data mine the answer to my questions so as not to waste peoples time on an issue that has a answer already. So if I have missed that I apologize in advance and would gladly read that thread if provided a link to it.

At any rate this is what I am trying to do. I work in a manufactuing environment which requires us to use SOP(standard operating procedures) We have an excel sheet that has a master list of all the plant SOP's. Then we have numerous other sheets(with in the same work book) that break down the needed SOP's by department. I have created hyperlinks from the the master list to all the appropriate file locations no problem. What I would like to do is find away to reference specific hyperlinks from the master sheet on corresponding department sheets so if the SOP is revised later that when I update the master sheet hyperlink the corresponding reference's on the department sheets will update with the new hyperlink address.

I am fairly proficient with excel and can crawl my way through some basic VB, so any advice or help would be greatly appreciated. If you need some more specific information I will gladly provide it. I will also attach the file that I am working with so people can see exactly what it is I am trying to do.

Thanks again,
Qppg