How to automate weekly averages from monthly data

[Bogus_Potatoes]

I have a spreadsheet in Google Sheets that my hospital uses to record medication changes made to individual patient files. Each month is kept on a different sheet, and each row is a new file worked on with the rows having that day's date as part of their dataset. I find it very easy to compute a monthly average using the "countunique" function, but having the averages for each week automatically update is proving challenging. I can have the data update with what week of the year each row comes from, but then using that to determine if a given row is within a desired week and then take an average is proving much more difficult. How can I have a cell's function query which week another cell comes from, and then if it belongs to that week, use it in an average for said week?

Also, since each month is kept in a separate sheet, weeks that span two months will need to be calculated as well, which will add complexity.

Sorry if this is confusing, or poorly worded; I have this idea in my head, and I'm not sure if it's even possible.