Data Validation or Combo Drop Box Worksheet Navigation

OK,

Here is an example of what I meant.

This is the fundamental idea. You could improve on this by named ranges in your sheet and VBA code...

This example ties together Data Validation List, Event Macro of On_Change and Selecting a Cell location.

Hope this helps.