Retrieving information from database and placing in other worksheet

First off just wanted to say thanks for all the help, When I got this project, I had not done any work with VBA, macros, and with your guys help I have learned quite a bit in last week. The current setup of this project have the summary sheets refer to the database to get the pertinent data using the sumif function which is pretty straight forward. what i need to be able to do is to retrieve the customers name and when it meets certain criteria like date ordered, model. I am really not sure how to approach this, I am not asking you to write the code but how would you approach doing this or where can i go to learn how to do it, thanks for the help.
data retrival.xlsm