4 Levels of Dependent Drop Down Boxes

I have attached my actual data I am using to show you what I have tried to re-create so far. I didn't want to overwhelm anyone seeing almost 3000 rows of data. I am assuming I need to alter the formula in column F to incorporate all 2652 rows which I did. I also changed the DivA and DepartA in the name manager to incorporate 2652 rows. Something weird is happening with the Department drop down though. It repeats the same Department several times. Is there something I am missing that I need to also edit for this to work?

I found the Name Manager by the way!

Thank you for any help you can provide.