Excel Macro

I have a spreadsheet that I need a macro to fill in the necessary fields. On the WORKING tab is a list of names in column B. Those names also exist on the Written, Plan, Matt, and Finalized tabs. They also exist as a part of the name on those tabs. For example, on the WORKING tab is Andrew Palacio - 205. On the Written tab in column A is also Andrew Palacio - 205, but there is also Andrew P (InHome - Carlos) - 2. What I need is to have column E totaled for every version of Andrew's name added up into Column C of WORKING. Then on the Plan tab I need every version of Andrew summed up into Column I on WORKING. On the Matt tab I need every version of Andrew summed into Column K on WORKING. For the Finalized tab I need every version of Andrew summed into Column O on working and any Protection Plans summed into Column N. The Protection Plans need to still be included in the sum for Column O, though. For all tabs except WORKING, only column E needs to be summed. All of this would need to be repeated for each user down to Other, which can be skipped. Please let me know what it would cost to accomplish this. I have also attached a macro that I began before I got in over my head. It cycles through each name and then searches the Written tab for that name.