is this ur fix data ? as in I saw there are spaces in sheet "team details" agent name column and also will you be able to do some find replace (ctrl +H ) action.

if u can then you can standardize all of the agent names in all sheet and then u can either vlookup or match-index ........

Many thanks
R