Inserting results into same-name columns on different sheets

[Houseofnerd]

Hello,

I am looking to design a macro that takes a final sum for each category and inserts that value into the appropriate cell in another data sheet.

My question is this: is there a way to create a function that looks at the first cell in that column, copies the result cell from that column, then inserts it into the result sheet's column with the same first cell.

Attached is a sample excel to illustrate how the data is set up.

Sheet 1 is how the raw data is set up
Sheet 2 is the second test of the raw data
Sheet 3 is how the results sheet is set up
Sheet 4 is how I want the final product to look

Thank you

[MaczaQ]

Hello,

Check attached solution, maybe it will be enouht for You.

Best Regards