If you want to post up a sample workbook with a range of cells hyperlinked the way you're imagining, then an AFTER sheet showing the results you'd like them converted to, I could take a crack. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
Bookmarks