Drop down menus and workbook sharing

So this is a shot in the dark.  I am trying to see if it is possible to create a drop down menu but have it pull data from another worksheet.  I am trying to create a way to easily select different o...