Extract 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 3 more sheets 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, and following a previous post havbe tried using suggested formula such as =FILTER, and =LET.

I ahave attached screenshots below of what the document is somewhat like at the moment. In Them there are two site 3 sheets. The alternative is in a f Layout similar to the one currently used on that site. This new workbook is to replace an old workbook with no conditional formatting and lacking necessarry info, wher hoghlighting and data input was all completely manual.

Sheet 1, uniquely column E is' A or B' as only two job types ar done on this site and all are delivered at appointment.

Sheet 2, Column E is now 'Delivery Method'

Sheet 3, Column E had been kept for conisitancy across the sheets despite all jobs being delivered at appointment.

Alternative Sheet 3, This is the layout similar to the current one used in teh business with a seperate diary for each technician for just this site, with a working week on the left most column.

Sheet 4, I would like all the jobs for one technician across the three previous sheets to automatically populate theis sheet using formulae.

Any help would be appreciated. Thank you.