hello, i'm hoping someone can assist me. for starters i am very new and inexperience in VBA.

scenario is:
i have four sheets, for simplicity lets call sheet 1 "names", sheet 2 "bob", sheet 3 "tom" and sheet 4 "sue".
on sheet "names" i have a drop list with the names and depending on which name is chosen the pointer will be moved to A1 of the sheet which matches the name chosen.

thanks