In Excel, you can create a drop down Data Validation list, using a list from another workbook as the source.

However, for the data validation to work, the workbook that contains the list must be open, in the same instance of Excel. Users will have to open both the workbooks -- the one with the drop [...]