Hi, I would like on the selection from a validation list to go to a
particular cell on another sheet [the same cell reference of each sheet for
each value in the list] is this possible.

Example
validation list would contain a list of student names -
Smith, Henry
Duck, Donald
Rabbit, Roger

Result-
Smith, Henry [hyperlink to C2 on sheet S1]
Duck, Rabbit [hyperlink to C2 on sheet S2]

Note: S1 and S2 are sheet names referring in brief to student 1, 2 and so on.

I hope this makes sense. I don't expect hyperlink will be the way to solve
this, perhaps a macro? or a vlookup?

Thanking you in advance.
Tanya