Good morning. I know it seems trivial but I want to create a sheet that filters and creates tables based on what I want shown. I created a mock up and some simple sample data but I'm not exactly sure what to google to get this working. If you can point me towards the correct keywords I can google how to make it do what I want or if you have time to help me I will greatly appreciate it. For the "make and model" I can use an index match to derive that portion of the data. I just really need help with the filtering and creating the tables automatically which I think is VBA or Macros.

Thanks

Here is the link to the excel sheet mock up I made. Please goto the mock up to see what I'm trying to create

https://www.dropbox.com/s/x162y8l7x5...2017.xlsx?dl=0