I have a sheet running that will add and sort carton/pick Qtys however is there any way for me to consolidate the information before pasting it into his sheet.

i.e. combine the unit count based off the Ref and description