I want to apply a drop down bar to all cells that is linked to a list in a different tab. But when/if someone wants to add something to the list, i want them to just be able to add it and it automatically show up. I know you can just include more cells that are not in the list already but i dont want a huge drop down bar of all blanks.

Thanks!