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(Master), where update has to be automatically by selecting MasterSheet. 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 link for the file. thanks a lot.
https://docs.google.com/file/d/0B6ngdl529IBTY1ltZ0pmMTZxXzQ/edit?usp=sharing
https://docs.google.com/file/d/0B6ngdl529IBTY1ltZ0pmMTZxXzQ/edit?usp=sharing