Data Validation based on another data validation

Hi there,
I am looking to create product bill of material based on a tab containing all my raw materials and then on other tabs I will build my products.

On each row I want to use one data validation dropdown cell to select the type of raw material (wood, plastic, screws etc) and then a second to choose the specific item from that category, but all of my raw materials are in one list all together.

Is it possible for the second data validation cell ("Item" in column C) to ONLY show the items that fall unter the category of the first one ("Item Type" in column B)?
Essentially using the first data validation dropdown to filter the second?

I have attached a sample worksheet to demonstrate.New Costing Database.xlsx

Any help greatly appreciated.

Hi Ali,
It's an extension on the same thing but a different apptoach to the problem so I figured I would post it separately.

Any help would be greatly appreciated.

Many thanks