Dropdown box selection modifies other dropdown box selections.

Greetings helpful redditors.
I have 3 cells, Departments, Division & Work Center.
I have 20 Departments, 63 Divisions and 135 Work Centers.
When I select Engineering Department, I would like the Division dropdown box change from all 63 divisions to just the 5 within Engineering. Then when I select Auxiliaries, change Work Center to just Auxiliaries work centers.
I have tried many duckduckgo variations of searches, but haven't found anything useful.

*I am unable to apply macros as Navy computers automatically disable macro's after launching them. If not possible without macros, I understand, and thanks for the help!*