Formula to calculate total time spent per person based on data from multiple sheets

Hello,
I have a several workbooks with multiple sheets. Each workbook is for a different date range and each sheet in each workbook represents a different date. On the sheets is the amount of time spent per person for that day.
I need to do a summary of the total amount of time spent per person across all the workbooks and sheets. Please see attached example.

So Column B on the 'Summary' sheet should pull data from sheet 'Day 1' and 'Day 2'. I would like the formula in B2 on the Summary sheet to look for 'Steve Rogers' in column A in 'Day 1' and 'Day 2' and where it finds 'Steve Rogers' it should pull the totals from column D and add the together.

Thank you, I'm realizing though that my formatting may need to be adjusted as well. I've set the Total columns on all sheets to custom (hh:mm), but the result I'm getting is a time rather than a number so if I'm then calculating a total payment from the 'Summary' Colmn B data then it doesn't calculate correctly.
For example Steve Rogers time should add up to 10.5 hours, which it is, but what I multiply by the hourly rate of $10/hr I'm getting $4.38, when it should be $105.00
I've updated the attachment to reflect.

Yes that's possible, but it's not my data and that's how the data owners want it saved/sorted.

I created a named range (Days) that lists all day tabs from cell K2 (Day 1 & Day 2 in your example sheet. List the other day tabs below K3
and, in the Formula ribbon, use name manager to adjust range properly in the Refers to box.

Then I use this formula to SUMIF from all day tabs.

Formula:

Please Login or Register  to view this content.

Finally, the correct formula in E2 should be:
=$D$2*B2*24

Please check file attached.

Good luck!