I have created a file to report data weekly. Sheet 1 is the report, Sheet 2
is the data. Sheet 2 columns are Date, Day, Data1, Data2, Data3 for a total
of 7 columns. I have entered the year of dates in the Date column and the
Day of the week in the Day column on sheet 2.

Sheet 1 has 3 sections. Section 1 is for the daily information on a week to
week basis. Section 2 is a summary of the weeks of the month and Section 3
is a monthly summary for the year. I'm able to populate the monthy summary
with formulas that refer to sheet 2.

How can I have sections 1 & 2 read sheet 2 and automatically pick up the
daily and weekly information on a weekly basis?