How to get names from a list based on multiple criteria

Hi,

I am trying to find/workout a formula which can help me produce a list of names which are taken from a separate worksheet based on multiple and potentially different criteria. I have attached an example to help try and explain.

In the example I have a home page where I can select from 3 different sites and also input a date. This will then give me a total of sales carried out on that site on the given day. I would then like to be able to go to a different worksheet (sales breakdown) where I can see a list of the sales people who have sold vehicles on that day. The issue that I am having is getting this page to only show the results and names for the site that is selected on the main page. I also have the added confusion where some sales people will go to work at different sites, for example N.Smith was in Manchester on the 13/4 but usually works in London. In the breakdown I would only want to see his name if he was at the selected site on the selected day.

I have filled in the example sheet to show what I would like to see to try and make it easier to understand.

Thanks in advance

Dom