Dynamic Lists

Hi All,

I would like to know if its possible to create a drop down list that acts like the table filter function.

In the attached workbook I have list of electric motors, this would be my product data base.

I would like to have a new sheet where I can select any of the properties (voltage, rpm, make, etc) from drop down menus and the other would filter just like when filtering a table.

So for eg if I select 24VDC in the fist option it would only show the 24vdc options in all of the other fields, just like a table filter. But on another sheet.

Is this possible??

Thank you.