Search and sum multiple worksheets based on criteria

Hello, I would be be very grateful for any assistance with the following:

I have a spreadsheet with approx 80 worksheets. They list cash payments that have been made to people each week for a year. The people change and come and go so the data is not the same in each worksheet but the format is exactly the same in every sheet.

I want a way for excel to look at a summary sheet with all the names and go through the workbook and add up all the payments made to each individual and place it next to their name?

Hopefully!

Joanne