I'm having trouble figuring out how to calculate weekly and monthly totals without having to input everything manually. I attached a sample spreadsheet and you can see what I am attempting to accomplish.

I want the weekly and monthly statistics to automatically input into the associated worksheets.

I've spent quite some time searching on the internet trying to find someone with the same problem, but I have had no luck.

Any and all help is appreciated.
Thanks,
Josh
TEST.xls