I'm not clear what you intend by "when you click on the title of a document, it opens it".

If you are talking about putting a hyperlink to a shared sheet in another sheet or some other Office document, that should work provided all the users have their drives mapped the same way. What is the hyperlink that you tried to use? Can you attach the document that has the hyperlink?