I have a workbook used for recording training. Worksheet one is the training
matrix, with the subsequent worksheets assigned to individual staff.

Each SOP listed in the matrix is linked to the staff worksheets, so I only
need to maintain one worksheet.

We now have a web-based repository for our SOPs. I have gone into the matix
worksheet and hyperlinked each cell to it's SOP. However, the linked cells
in the staff worksheets are not hyperlinked. They just display the SOP Title.

The formula I'm using is =+Matrix!A1

Is there a way to carry the hyperlink to the linked cells?