Say in cell A1 I create a drop down (Data Validation > List > Invoice1, Invoice 2)
So I add the Invoice 1 & 2 right into the data validation.

Now when I click cell A1 a drop down appears
Invoice1
Invoice2

Say a user clicks Invoice2... soon as they click it.... I would like it to jump to cell b1000 (in the same worksheet)