Dynamically filtering rows from one sheet to another based on cell values and reordering

Hi Guys,

So grateful for the help that has been given to me!

I'm sure this is simple enough.

Our band has a DIARY which is edited in Excel Online.

All data is entered on GIG DIARY sheet.

On other sheets I want to dynamically filter rows from GIG DIARY to show the following (and preferably not all Columns):

INQUIRY Sheet
STATUS=INQ
Have them arranged in date order of INQ DATE Column (Inquiry Date)

PLAYERS BOOKING Sheet
Have a list of Bookings for each player
STATUS=BKD or AWT CON or AWT DEP

Only shows certain columns, such as GIG DATE, VENUE NAME, GIG STATUS, TOWN, PLAYER FEE.

Look forward to your responses!