Macro to scan multiple columns and find total sum of each unique item on a list of unique values

[Oraekene]

Good day. Been struggling with this and would appreciate some help. I'd like to write a macro that goes through multiple columns in a sheet and sums the total values of each item beside it's cell in a unique list. Similar to how to find for eg. sum of total sales for multiple months for a particular product. I have attached a sample sheet to explain. The update sheets are to show how the input data worksheet would expand over time, so the code would need to work for a dynamic range. So far working on it i've found i might need a SUMIF INDEX-MATCH array function, but i don't know how to write it. I use Excel 2013.

Would be grateful for any help

Here is the sample sheet: Sample sheet

 

[Oraekene]

This should be a new thread as it is a different question.
If you want to post a link to it here I can take a look to see if it something I can help with.
You will need to explain the calculation you want. Is the calculation trimming off at the row level or are the codes being totalled first and the trimming happens as the total level.
How would you do it in Excel directly ?

Good morning (where i am). So i created a new question with a sample workbook showing exactly what i'd hope to achieve. Here is the link to the thread VBAthat does a sort of index-match to find all the count numbers of an address across a range, and find the trimmed mean of those prices

 

[Oraekene]

Good morning (where i am). So i created a new question with a sample workbook showing exactly what i'd hope to achieve. Here is the link to the thread VBAthat does a sort of index-match to find all the count numbers of an address across a range, and find the trimmed mean of those prices

Would be really grateful for your help on this