A google search for 'dynamic drop down list' yielded a few results. Here is one: http://www.contextures.com/xlDataVal02.html

As for locking the selection, maybe something like this: http://www.mrexcel.com/forum/excel-q...down-list.html