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.

How to create a nested drop-down list in Excel If you want to obtain data from some existing drop-down menus or cells and display options accordingly in a different cell, here is what you can do.