Dependent Data Validation with Dynamic Range

Using Excel 365   Hi, First, thanks in advance for the help, and sorry for the long post. I am currently creating a document using dependent data validation. I have three categories of data that I...