I found this previous thread that is similar to what I need but haven't had joy with any of the codes provided (super noob in the world of VBA).

I need to merge different Excel sheets, where column A, C & D are exactly the same. If this is true then the values column (F) should be totaled and merged to make one row of data. The remaining cells not mentioned can be the same and aren't too important. I've used Power Query to merge multiple sheets and append so all appear in one document (if there is a better way to do this then open to suggestions). Just need help with this part.

Any help would be greatly appreciated.