Excel formula that sums hours from everysheet sorted by date

[mysticmario]

I have this excel hours sheet which I would like to to automate summing up working hours for the entire month.
The formula that I ahve in mind has to check the date and the name of the employee and then sum all the data from each sheet across the entire workbook matchign those 2 conditions and print sum of the hours for this day into another sheet.
Here's the video showing what sheets are involved in the process.
Side note the hours are stored in each sheet seperated by project number, but every single sheet that has the hours always starts with text "Godziny"

2022-09-13 11-34-37.mkv

drive.google.com

I dont know if I explained it well, if you have nay follow up questions I will anwser them swiftly.
I can have this using VBA aswell, but this xlsm is packe dwith so much VBA that I think it would be better using the formula(maybe).
@edit In the video I have mistakenly added hours form 20.12 and 21.12. Of course what i mean is to sum hours from 20.12 which is 7 not 17, but you can see what i mean

 

[mysticmario]

I've been searchign through web it deosnt seem possible to use formulas for that, unless someone is more knowledgable in this regard

 

[mysticmario]

is anyone able to help creating this tool?

 

[mysticmario]

I figured the best way to start is to make SUMIFS formula which works on sheet, so i mae a mock up but still failed here's a Screenshot.
So in this example I want to pick hours of employee named "Janusz", the formula has to find employee name in column N, then find date from A10 in P7 to V7 range and sum hours fot that day and for that employee stored in P9 to V28 range.