1) In Sheet3 create data list
datalist

2) In Sheet1, create main inventory list
mainlist

3) In sheet1, select A2 to A10 and click on Data Validation
Select_User
In Allow column, select List
In Source column go to Sheet 3 click on Alice and press Shift key then click on  Wendy to select all
Sheet3_A1toA9
DataValidation_Final
Click ok

3) Go back to Sheet 1, you will able to select user from the drop list
dropdownlist

Final Product
finaldropdownlist

Advertisements