i would like to set up a spreadsheet that would have a master list on sheet
1 that would automatically track how many items a person obtained on the
next. For instance:
"Sheet 1" will have John Doe in cell A4. Would like for B4 to compile a
total of all numbers listed the other sheets. Keeping in mind that John
Doe's name may be listed multi times in theb other sheets. Hope this makes
sense