Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

Data validation in Excel allows you to create drop-down menus right inside individual cells.

TechRepublic: In forms, it can be useful to limit the choices for a selection with a simple drop-down list. This is also possible in an Excel spreadsheet, but the process isn't well known or ...

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Data validation in Excel allows you to create drop-down menus right inside individual cells. You can also restrict the types of values entered into different cells.

Excel enables you to include data validation for a cell, limiting the type and content of any inputted data. In addition, you can limit data to a drop-down list of choices, further restricting ...

This trick works across the workbook. So, if you are on a different sheet and select a bookmarked cell from the drop-down menu, Excel jumps to that cell on another sheet.