Extract Rows of Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria.

I'm working on a scheduling document where I have manufacture jobs being undertaken across three sites, each of which have their own sheet to track jobs with information including the due date, client name, employee, and some job relevant codes as well as some tick boxes (nine columns per table).

I am attempting to create a 4th sheet to track jobs across all 3 sites undertaken by a single employee to be used a tool for good prioritising. I would like to be able to take the full rows of information from the existing three sheets and have them automatically populate the 4th, and be able to sort the 4th sheet by a due date column.

I have played with =FILTER functions and tables converted to ranges, but haven't found a solution where the the table can be filtered and self-populatin from the 3 sheets at the same time. It's either one or another.

Any help would be appreciated. Thank you.