In worksheet we can create dynamic drop down lists with the Data Validation feature and the Indirect function. Watch the video to see how it's done :