Function to lookup between multiple worksheets and sum

Need Excel function to perform lookup from multiple worksheets

Worksheet 1: Faculty Database
Columns:
List of Committees
Faculty that are members of each committee
Hours spent per member on committees

Needed: Excel function on worksheet 2 under total hours for committees to lookup from worksheet 1

Worksheet 2:
Columns:
Faculty Name
Total Hours spent by each faculty member on ALL committees from sheet 1.

It is taking me too long to filter by each faculty name, sum up the amount of total hours spent, and add it to the second worksheet.

Would appreciate any help. Thanks!!

Hello

Could you please post your workbook?