I'm am having trouble linking/referencing a cell that contains another
hyperlink.

There is a master list on one tab, that has hyperlinks to all documents
listed. Our other tabs (within the same spreadsheet) contain the same
information that is stored in the master list tab, but specific to a group.
(i.e. a training tab, lists only the training documents)

The idea is to maintain only the hyperlink on the master list page, but
allow others to click of the hyperlink to a document on their specific group
tab, and it would open the document.

Originally, I just used the "=" function, to get the data, but the hyperlink
didn't work, only the text appeared. I've done some online research and
tried through other forums and tested the possible results, but nothing seems
to allow me to have a hyperlink, that opens another hyperlink (that opens to
a website) within the same document.

Any help is appreciated