See how to create a dynamic data validation drop down list based on another dynamic data validation drop down list using excel list / table feature.
Excel 2003 List; Ctrl + L
Excel 2007 Table: Ctrl + T
Also see related video:
YTLE#75: DV Drop-Down based on DV Drop-Down
English