I'm not sure I understand exactly what is going on in your spreadsheet, but it looks to me like one of those cases where a lot of things will be simplified if you will combine all of the "SO1" type sheets into a single, large database. Then use pivot tables and/or SUMIFS() functions to add up the different values you want.

see links in this post: https://www.excelforum.com/excel-new...ml#post4906705