Drop down lists based on selections in previous list

Hello!

I'm trying to create a clean up template for our online data content for some of our websites. One of the things we will need audited will be the "Categories" of products.

We have a three tiered categorical system. So an example might be having a Pendant Light.. but it comes in a few sub varieties such as Multi-light, Tiffany, and Island pendats. And then each of those might one more tier of categories--transitional, traditional, and contemporary.

So in other words, I want to set up a list system that qualifies what the selection of the next list based on what the user had previously selected. Is this possible providing the data is referenced on the sheet somewhere else...?

As it stands currently someone might select "Pendant" Master Category (column d) and then someone Barbeque as a regular Category (column e). This obviously makes not sense. :]

Any help would be much appreciated. Thanks in advance

Please see attached