I have multiple sheets.
Each contains sales person's name across top and their commission per month
down the column. each sheet is for a different project.
I need to creat a summary sheet with sales person's name on top and their
total commision from all other sheets per month down the column.
So, I need to lookup sales person's name from the top row, match with month
from the left column and add all corresponding commision figures from a range
of sheets.

Appreciate any help.

Happy New Year to All.