Consolidate Worksheets (and new added sheets) into One Worksheet+ sum by date & customer

[guatelize]

I'm using a workbook containing a worksheet with same layout for each customer with their orders & delivery quantities by date and means of transport. I want to consolidate all the data from the different worksheets into one worksheet (Summary), where update has to be automatically by activating the sheet Summuray. Other sheets are added weekly with new customers. I have been looking everywhere to consolidate with a macro or udf, but could not find the exact solution. Can someone help me ? Thanks a lot.