Microsoft Excel can emulate this functionality by linking cells that reside in different worksheets and workbooks.

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users ...

How to populate from another sheet in Excel You can populate a dropdown with a list on another sheet by referencing the cells, but the resulting dropdown won’t be dynamic, even when the list is ...

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