I need assistance with creating a workbook and linking names from two different worksheets

[v1c1986]

Hello,

Here's what I need assistance with creating

Final Product - Overall roll up of numbers by Supervisor

John	Phone	Email
AHT	80	50
CSAT	70	75

<tbody>
</tbody>

Data source 1 - List contains Supervisors and there agents

Agent	Supervisor
Tim Jones	John
Brad Johnson	Sarah
Sarah Smith	John

<tbody>
</tbody>

Data Source Two - Contains Agent data

Agent	Phone Aht	Email AHT	Phone CSAT	Email Csat
Brad Johnson	80	50	65	70
Tim Jones	70	80	60	55
Sarah Smith	75	75	75	80

<tbody>
</tbody>

There has to be away for me to link the agents to supervisors and then roll it u as a summary- Data source two comes from a database that is unable to match agents with their supervisors. So I need to create a supervisory report.

 

[v1c1986]

Any help would be appreciated