Copy data from One Spreadsheet to another based on a particular reference

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?

Pl copy sample data to a separate file with all details required and attach that sample file.

Attached file as per request. (Zipped the file, hope that is ok)

with the master data spreadsheet i have a match/offset function as a quick reference quick on the booking number reference.
Data to be entered from Row 8 as per example shown.

with the reference tab, I want to be able to use a drop down reference on the coloured in cells based on employee name, department and or state to filter any data from the Master Data to then reference based on the drop down cells

Pl See the attached file.

Using worksheet_change event columns E,F&G are unique filtered to BE,BF & BG columns.Ranges are named and used or validation.

Any clarifications welcome.

I am little confused.
What I am hoping to be able to do is by selecting one or mulitple drop reference(s) from the "Reference" Worksheet it will pull the matching data into the same formatted table below on that worksheet from A6 etc.

as per the sample data if J.Friend was selected than two rows of data would be transfered to "reference" worksheet.
The data in columns E, F and G are unique values depending on the staff name, their dpeartment they work in and their destination of their travel booking. all the other columns will be manualy entered data like booking numbers and costs per booking etc

that does a little easier.
However I am not too familar with the use of tables in Excel.
The purpose of the spreadsheet is for it to be updated fairly regularly with a average of 20-30 bookings of travel a month.

There is also other worksheets I have providing other brief summaries of the master data (not attachted), but I am trying to drill down on individual bookings per staff etc.

so if a table maybe a solution that would be great help

that works great

thank you very much, you have been very helpful

Ok Thanks for compliment.
Pl mark the thread solved.