View Full Version : Consolidate Worksheets(and new added sheets) into 1 Worksheet+sum by date & customer

02-07-2013, 08:04 AM
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. 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 ? I've attached the file. thanks a lot.