From the data worksheet, highlight departments → select from Formulas tab DEFINE NAME → new name and enter name as “Department” (also you can just name the list in the name box).
On the ClientDept worksheet insert the list by highlighting cells B12-B15 → select DATA VALIDATION from the Data tab → in settings tab select allow list, and enter source =Department, select in-cell dropdown and ignore blanks should be checked off