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 ...