Is it possible to use data validation lists to create pivot tables in VBA?

I have created a page that calls data from a spreadsheet, but I only want certain rows with specific choice criteria. The criteria would be in a drop down list from a data validation, and the list referencing a row in the spreadsheet (see attachment). Is this done with VLookUp or Pivot tables or even a combination? There are two pages included (but 100s more exist) where the data would come from.