I have a list of names in one tab. I need a total in one of the columns which comes from another tab with the person's name. Is there a formula I can use so I don't have to build the formual each time. Current formula for each person. ='doe, jane'!E5.
I don't know if there is a formula that goes to the next tab verses the next column or row. Just thought I would ask.

Thank you.