Multiple Conditional (Dynamic) Dropdown Boxes

I'm trying to incorporate multiple conditional (Dynamic?) drop down boxes to enable me to get an appropriate code at the end of the process. This will be used to product data entry and the code will tell Amazon where to post the product. I have many thousands of codes that i need to access and the easiest and most accurate way is to break down everything in to category and sub categories until I eventually get the code I want for that specific product.

for Example:

1730708031Clothing/Baby/Baby Girls 0-24m/Hoodies & Tracksuits/Tracksuit Bottoms

To return this code I would want to select Clothing, which returns a list which includes baby which in turn will give me a list that includes baby girls and so on and so on until I can select Tracksuit bottoms that will return the code.

Each list is dependent on the previous choice

As I have thousand and thousand of potential codes creating range list for each potential category and sub categories is not really feasible and would be very difficult to maintain when changes occur.

With this in mind I have created a code list that breaks the above example so that each category is now in it's own cell and there can be upto 8 (as I've seen so far) potential conditional categories before you return the code and ideally I would like to use this as it very easy to create and update. (see attached)

I might be able to use filters to return the appropriate list each time but don't know where to begin.

ClothingCodes.xlsx