@butchpt6 There are many ways to achieve this, all depending on how your data is structured. You write about "the very basic picture ...... above". If you intended to upload a screenshot, it did not come through.
Attached workbook contains two simplistic examples. One using AVERGAGEIF and the other one uses a Pivot Table.
You mention that you want results to go to separate tables and separate sheets for each week. Probably not the best way to go, I think. But if you could upload an example of the data you collect (delete any confidential information, though) and the kind of results you would like to see, it would be much easier to come up with a solution.