Learn how to create dynamic drop down based on another cell using Indirect and Match functions. You will get dependent multiple selection dropdowns that will update automatically as you keep adding new data.