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 options and have it displayed.  I would have 10 selections in the drop down menu and it would be able to display numbers.  Thank you.