Copy cells from another sheet depending on date

Hi,

Not sure this can be done with formulas but it will be a shared file so can't use VBA
Excuse the design, this has been stripped for sharing purposes

Sheet 1 is a sample of a working worksheet, the Week Number in cells C4,P4,C25,P25 are formulas based on date in cells D5,Q5,D26,Q26 so will update week on week
The date in D5 looks at today's date and returns the Monday of that week, and all other dates are D5+1,2,3... etc so the 4 weeks will always show Monday to Sunday
The month in rows 4 & 25 pull from the date in rows 5 & 26
All this works fine and will constantly show a rolling 4 weeks from the Monday of the current week.

Sheet 2 is a new sheet where I will collate data on a weekly basis, there are no formulas for week numbers or dates as this sheet will include an entire year.
In this sample there are only 6 weeks to see if what I'm looking for can be achieved.
For each Line 1, Line 2, Line 3... etc, Monday to Sunday, there is an in-cell dropdown list Yes,No,Maybe (data validation is for sample, this will change)
User inputs data on Sheet 2 for specific "Line" Monday-Sunday

What I'm looking to achieve is the data from Sheet 2 copied to Sheet 1 but matching the week number, then I would have an auto populated rolling 4 weeks.
This would mean I need formulas on Sheet 1 D6:J22; Q6:W22; D27:J43; Q27:W43 to reference Sheet 2 of the corresponding week.
I'm just not sure this can be done with formulas as what is currently Week 22 next week becomes Week 23 and so on.
Sheet 2 D7:J23 to Sheet 1 D6:J22
Sheet 2 L7:R23 to Sheet 1 Q6:W22
Sheet 2 T7:Z23 to Sheet 1 D27:J43
Sheet 2 AB7:AH23 to Sheet 1 Q27:W43

I could possibly use a non shared workbook that collates data from sheet 2, uses VBA to achieve what I want and then sheet 1 pulls from that unshared workbook. Formulas on Sheet 1 would be easier though.

Any help greatly appreciated

Oh wow, yes!

It looks to be just what I am after, I'll roll it out to the actual workbook and then I can manually change the date in D5 to check it works fine week on week.

I assume I just change the reference to AX to the last cell in range when I expand my data for the entire year?
=LET(a,INDEX(Sheet2!$D$6:$AX$23,MATCH($C6,Sheet2!$C$6:$C$23,0),MATCH(Sheet1!D$5,Sheet2!$D$6:$AX$6,0)),IF(a=0,"",a))

I wasn't expecting a reply so quickly
Thank you so much