I have two worksheets, one with all the data entered and i am hoping to automate the second worksheet for referencing particular data based on one or two drop down cell references.

Tab 1 - Master Data - is where numerous staff enter data of travel booked. also note that there may be numerous entries for a individual staff member due to different trips etc

Tab 2 - Reference - is where staff can look at either, "Employee", "Department" and or "State" based on the drop down listing in cells E2, D2 and F2 respectively.

How can select either or multiple drop down references to filter the data from the Master Data worksheet to show in the Reference worksheet?
Tried attaching copy of file, but file is too large, any other help how I can show you my dilemma?