Copying, paste and concat certain data to one sheet

Hi All,

Is there any way or a good way to copying & concat what I highlight on different sheets to the main sheet?

There's a example of what I wanna achieve and how it look like in the main sheet.

The things I'm stuck on is the concatenate on sheet size to the main sheet is there anyway to do this without vba?

@Sambo kid

Apologies for not being clear enough, not really good at explaining things. As you can see in the workbook there’s a packing list, invoice and size worksheets. These are the sheets I wanna pull the data from, the main sheet.

The main sheet is completely blank and it’s where I want to store the data from the other sheets. On the invoice I wanna pull the data from colA,B,C and E to the main sheet colA,C,D and H. The packing list ColC is the same as size sheet colA instead without the letter in front. Packing list colC is showing how many cartons of the same product, and size sheet is showing the size breakdown in each cartons. But both sheets are not showing them in order for example maybe product A carton c-2 is in row 12. But in size sheet the breakdown could be in row25.

The bit where I stuck on the most is to concatenate the size breakdown into one cell. In the example It will be 12=51,8=70,10=69,6=48,16=18,4=31,14=33
Then I would need to add UK and which cartons are they from like this.
M-4:UK12=51,M-5:UK8=70,M-6:UK10=69,M-7:UK6=48,UK16=18,M-8:UK4=31,UK14=33
Onto main sheet colG.

I hope I explain clear enough can this be done?

Hi

I kinda manage to get somewhere.

Please can someone review and give me feedback on any better way of achieving the result in Main worksheet ColD I had without vba?

I kind stuck on with the index match aggregate to return multiple match on Calculate worksheet colE, not quite getting what It's showing in Packing list worksheet colC, which is why I use a dummy colB to test things out. Any help on this?

Thanks