Find names in one sheet (cells A2:A33) from 12 different sheets and add the total (column are not adjacent) that is in another column to another sheet

[Devianey26]

I have an excel book with 13 sheets. The first 12 sheets are months (Jan-Dec) and the final sheet is The "Total Sheet" where I add the totals of each name from each sheet. So,

If I have the name, John Doe, in column A3 of sheet "Jan" and again in column A20 of sheet "Mar", I want to "sum" their totals located in column D3 of sheet "Jan" and D20 of sheet "Mar" (because these are the cells where the name appeared within the respective sheets) and add the total of each occurrence into column B2 of the "Total Sheet". I also want to copy the name to column A2 of the "Total Sheet", the first time the name is located. In the "total Sheet" I only want the name once, I don't want the name duplicated.

I can do this with VBA but because I need to use this Book in "Microsoft Teams" I can't use micros. So I want to know if I can do this with an Excel formula.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)