Compare names in columns and copy paste totals in matching columns on different worksheets : I need to create a Macro to compare last names in columns on 2 separate worksheets, and when there matches with the last names copy and paste totals from a different column from one worksheet to another.

[Sheet1 where the totals should be copied to, once names on both sheets match[\]\[1\]][1]


[Sheet 2 where the totals should be copied from once the names match][2]


  [1]: https://i.stack.imgur.com/UnqeW.png
  [2]: https://i.stack.imgur.com/d3Q7v.png