Section wise summarize the data into one sheet from other work sheets

As you are using the 365 version of Excel I suggest utilizing Get & Transform (Power Query) to produce a row over row table as modeled on the PQ Table sheet.
First convert all of the ranges (A2:F11) on the daily sheets to tables (I recommend giving them meaningful names i.e. Table01.09.20).
The Power Query advanced editor code used to produce the table is:

let
    Source = Excel.CurrentWorkbook(),
    #"Expanded Content" = Table.ExpandTableColumn(Source, "Content", {"Number", "Under Section", "Qty", "Man Power", "Machinery", "Section"}, {"Number", "Under Section", "Qty", "Man Power", "Machinery", "Section"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Expanded Content",{"Name", "Number", "Under Section", "Qty", "Man Power", "Machinery", "Section"}),
    #"Filtered Rows" = Table.SelectRows(#"Reordered Columns", each ([Number] <> null)),
    #"Reordered Columns1" = Table.ReorderColumns(#"Filtered Rows",{"Name", "Section", "Number", "Under Section", "Qty", "Man Power", "Machinery"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Reordered Columns1",{{"Section", type text}, {"Number", Int64.Type}, {"Under Section", type text}, {"Qty", type number}, {"Man Power", type number}, {"Machinery", type number}})
in
    #"Changed Type"

Note that the above code will find all of the tables in the workbook.
The formula for Ref Number is: =IFERROR(INDEX(Query1[Number],MATCH(0,INDEX(COUNTIF(A$3:A3,Query1[Number]),,),)),"")
The formula for Work Done and the first Total Qty is: =IF($A4="","",INDEX(Query1[Under Section],MATCH($A4,Query1[[Number]:[Number]],0)))
The formula for Man Power and Machinery is: =SUMIFS(Query1[Man Power],Query1[[Number]:[Number]],$A4,Query1[[Section]:[Section]],$D$1)
I don't understand what you want for the second the third Qty columns.
Let us know if you have any questions.

It should work with any number of tables in a workbook.
The formula for the Qty columns could be similar to: =IF($A4="","",SUM(D4:E4))
Let us know if you have any questions.

any how solution done...Thanks for your support.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.