Multi Column Dependent DropDown List for Product

I have two sheets One named as Furniture with Products on it and second name as material with Brands, Material Type, Name, Categories and colour code(we keep adding new material from various brand to this data.

https://filetransfer.io/data-package/fOLBqxaY#link

I want help in fetching all this material data to my Furniture sheet. So basically a buyer select the product code, and then they have to enter all these material and brand detials.

Lets Say for product 1, buyer select Brand "ABC" from drop down list, then other material related columns should be dependent on it. For example in Brand A, WE have 5 types of fabirics, then it should show on those 5, then based on which type i select it should give the name of fabirics lies in those material type , than based on material type selection it shows the categories in drop down.

Brand is independed and can only show the brand list Material Type is dependent on Brand Material Name is depenedet on Material Type Material Category is dependent on Material Name Material Colour is dependent on Material Category.