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

How to Copy From Word to Excel. As two peas in the Microsoft Office Suite pod, Word and Excel share many similar functions, including nearly identical ribbons, tabs and menus.