To download the example file please visit http://www.bluepecantraining.com/portfolio/excel-drop-down-list-with-dynamic-range-source-data/.This video explains how to create a drop down list in Excel which will automatically update when you add new values to the source data. There are a numbers of ways of doing this in Excel - this video explores using Excel Tables as a solution.
------------------------