Instead of using full columns for your defined ranges maybe you could use Dynamic ranges

Fi the range named "department". instead of defining the range as "D: D""( which is very long) try
And the same for your other named ranges

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post