Total Help

catherine9910 An easy way? I would say NO, but it's not all that difficult either. The way to go would be to use PowerQuery (provided you're not on a Mac).

If you have never used PQ, it's going to require some learning, but once you master the basics you will love it. Do you have the monthly tables in separate worksheets within one workbook or in separate workbooks (one for each month?  Either way, PQ can connect to these tables and append them (i.e. make one big "table" from them). Then you need to perform some clean-up steps, before grouping all information by Name, Month and Carton size. Once this has been set-up correctly, you can add data every month, push a Refresh button and you're done.

If you could upload data for, let's say. three months, that would help. Use fake names and numbers, so that you don't disclose any confidential information, but make sure that the structure of the data sheets is real.