HELP count how many cells are in a specific week number per month

Hello. Please help. I badly need to track the orders (or codes) that needed to be completed in the specified date. This is my Data looks like (sheet1 named "April." my date is horizontal instead of vertical):

"refer to attached screenshot"

In a separate sheet (sheet2 named "Summary"), I created the below table to gauge on how many codes are expected be completed in a specific week (based on the dates in sheet1:

"refer to attached screenshot"

I have Sheet3 (named "Sheet1") prepared as reference for the dates (column A) and their month number (column B) with the week number (slightly altered as I need exact week number of the month i.e. week 1, week2, week 3, week 4 or week 5 or the month of May):

"refer to attached screenshot"

What I want to do is get the date fom sheet1 for the expected completion dates and reference it with sheet 3 and count how many codes and record it in sheet 1.

PLEASE PLEASE HELP. *sorry for the sheet naming :(

Thank you very much for helping me on this. One question though, the sheet named April, next week, I will need to create another sheet named May and input data there same as April the formula (the long one) I noticed has the April sheet only as reference.

What if I created another sheet for codes that will be assigned to me starting next week and named it "May" (different month different sheet).

I still want the Summary sheet to still capture and count the codes of the completion dates regardless of the sheet the dates are entered. It will still be in the same row though - row 3.

Please help.

We are expected to complete 80 codes per week which I just thought the file will be difficult to open or modify which such a large file size as data gets added in just one sheet. Still, thank you for all of your help. I appreciate it.