Use a dropdown to filter a table

I have a table with 10,000 + items. to filter i added 5 columns: Paving, Iowa, Nebraska, Non-DOT, and Rebar. The new columns will have Y/N, and some items will have multiple Y's and/or N's. I need a dropdown with the new columns, and i need to filter the list by the Y in the column. I split the main list into several smaller lists thinking i could use datavalidation to select a specified list, but i can't figure out how. please see the attached. the main reason i want it this way is to simplify estimation for others: select table then select item, populate price, multiply quantity-- all on one line, then copy that line down and repeat. the result would be a list/table i could then import to a form that we send to a customer.