I would like to create a cell where a user can enter a value (1 thru 4096),
the entered value will jump them to the corresponding row. Can this be done?

or should I simply create a worksheet that performs a lookup to another sheet?