Creating a Drop down list that will take you to a specific place on a worksheet.

.
This is just one of many websites that provide instructions to utilize Data Validation Dropdown with hyperlinks :

https://www.excel-bytes.com/how-to-u...tion-in-excel/

Search for VBA Data Validation Drop Down Hyperlinks