Yes, exactly. Sorry for leaving that very important part out.

I am looking for a macro/some other functionality that will automate this process given the large number of drop down lists. Additionally, the data will change in the future, and I want to avoid manually doing this process each time.