This video explains how to create a drop down in Excel based on a list on another worksheet. It also explains how to get those drop down menus to automatically copy down into new records.

This tutorial will help you:
Create an Excel drop down list from another sheet
Create a drop down data validation list from another worksheet
Create a drop down that pulls data from another sheet
Populate a drop down from another sheet
------------------------