To keep your drop-down lists current, use data validation lists that automatically include new items. Set up your list in an Excel table, which is dynamic and expands as you add new data ...