How do I insert a drop-down list from another sheet in Excel?
Insert drop down in Excel from a range of cells
On the Data tab, click Data Validation. Place the cursor in the Source box or click the Collapse Dialog icon, and select the range of cells to include in your drop-down list. The range may be in the same or in a different worksheet.