Add data across multiple sheets by identifying common string

[jazR727]

I have a few dozen sheets that I need to do the following with:

• Column A in each sheet has an individual's identifier (name)
• Column B has a number corresponding to that individual
• I need to add the numbers in Column B across all sheets for each individual in Column A

This would be simple if the list of people in Column A was identical across every spreadsheet. However, it's not because the list changes across sheets. So some individuals may not be on all sheets, and since they don't have the same list on each, "John Jones" may be A20 on one sheet, A25 on another, and A30 on another. If an individual can't be found on a sheet, I'd like it to pull in a "0". Is this possible? Thank you.

 

[Tetra201]

A similar question answered here.