linking schedule with images

I have a schedule of students coming to our insitution that I post publicly
on our intranet. This schedule is populated from our main spreadsheet (so
all cells have links to the main spreadsheet).
I want to be able to click on a students name and have it go to another
tab&cell where their photo is. I tried doing 'insert/hyperlink'.... but as
soon as I update the schedule the hyperlinks are all screwed up (then
realized it's the cell not what's in it). As there is already a formula in
the cell I'm not sure I can add on, or even if this is possible.
--
M