Need fornula to calculate week total of individual from sheet data

Dear Expert

I have set of data which contains individual team member weekly updated roaster report,

i have weekly sheet i want find how many shifts hours covered by each week individually in table. 1 and table 2
table1 result shows data sheet, table 2 shows nos
if i select G5 team emp name report will show from Data Sheet table according Date and Weeknos.

column A:A Date between for weeks i will assign date range later for all the dates.



I have table set the weeknos table from 01/23 till 12/23. and have scenario sheet which represent the hours table

formula need to fill from C11

Find the attachment