Return the relevant cell value on a specific date on excell

So I'm using an excell workbook to keep a lot of data in different sheets, including my payments (as a sheet on the same workbook) for specific dates. Since this workbook has a lot of sheets i made the first sheet as a cover page that returns the selected cell values that i choose to make some kind of a summary of all the sheets.

What I'm stuck at is writing a formula that returns the total payment amount specified on a cell on the payments sheet to the summary sheet.

The total payment of a day is calculated with the =sum() formula just below 12 rows of the date value in the payments sheet. I wrote =Today() on the summary sheet to the cell H26 and i want to see the payment that I'm going to make on that day on H27.

Verbally, the formula that i need is "if a cell value in sheet x is equal to H26, return the value that is in the same column but 12 rows below from that matching cell but i don't know how to do it.