Create a validation list in E2 pending on D2

You could use a Worksheet_Change event to fire off a Autofilter and then use the results of the autofilter to create the drop down validation list - see attached workbook. The only catch is that you would need to have the list ordered in Column A otherwise a different approach would be required.