Formula to create summary from different worksheets

Have you heard of PowerQuery? If you are using 365, then you have it. Interested?

OK - I'll have a look at your sheet.
better
One question: could the layout of the master sheet be three tables side-by-side instead of stacked? This would facilitate the solution.

You could put the result tables onto three different worksheets.

Or you could freeze the columns on the left of the page.

Hopefully Olly will see this.

Perhaps the following will be of help.
1. Name all of the tables on the 10Jul19 and 17Jul19 sheet naming them according to zone i.e. zonea_10Jul19
2. Use the following power query advanced editor code to produce an overall tbl_10Jul19 table (modeled on the 10Jul19 sheet)

let
    Source = Table.Combine({zonea_10Jul19, zoneb_10Jul19, zonec_10Jul19}),
    #"Added Conditional Column" = Table.AddColumn(Source, "Zone", each if [#"Plot No."] <= 5 then "ZoneA" else if [#"Plot No."] <= 10 then "ZoneB" else "ZoneC"),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Conditional Column",{{"Zone", type text}}),
    #"Added Conditional Column1" = Table.AddColumn(#"Changed Type", "Table", each if [#"Plot No."] >= 1 then #date(2019, 7, 10) else null),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Conditional Column1",{{"Table", type date}})
in
    #"Changed Type1"

3. Use the similar code (select tbl_17Jul19 then edit then advanced editor) to produce the 17Jul19 table
4. Use the following code to produce a combined table (tbl_combined)

let
    Source = Table.Combine({tbl_10Jul19, tbl_17Jul19}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Plot No.", "Zone", "Table"}, "Attribute", "Value")
in
    #"Unpivoted Columns"

5. Produce a pivot table using the modeled on the desired result sheet. Plot no. and zone are in the row field, table is in the column field and the values are in the value field. The attributes, foundation; MEP and structure are placed in a slicer.
Let us know if you have any questions.

Unfortunately no, however perhaps the first part of the linked video will help you set things up.
https://www.youtube.com/watch?v=jVkWDZ7B-Zs
Let us know if you have any questions.