How to hide previous weeklytotals, display cumulative monthly (hide previous months)

I am creating a workbook for my company's employee safety incentive program.

We have 12 categories of items that add or subtract from an employees safety points for the given time frame(weekly, monthly, quarterly, yearly) as part of an incentive program to promote a safer work environment. It's in the construction industry so without being too hard on my fellow office workers, a simple to use spreadsheet is a must. This means editing/inputing/calculating data by hand should be kept at minimum as most of my coworkers would be unable to continuously update the formulas and things within the spreadsheet on a weekly basis.


What I envision is this:

Worksheet Page 1:
Employee names going vertically down the list
12 Categories for point accumulation running horizontally across the page(some are worth -3, a loss of all points, +3, +1 etc)
Current Week, Current Month, Current Quarter, Yearly totals running horizontally after the categories

Worksheet Page 2:
Helper tables for all previous inserted data(in case of audit/needing to print certain date ranges/employee totals)


The issue I am having is understanding how I can make each weekly column hidden unless it is the current week. I need the inputting data to be saved weekly(Friday morning perhaps?) updated into the correct monthly data set(which is only displayed for the current month, then added to the quarterly data set at a given interval and displayed for the current quarter, whilst continuously updating the yearly totals.



The idea behind this is that my safety manager will only have to insert either a 1, or leave the field blank in the point earning/losing columns once per week, and have the excel sheet update the other numbers in real time, and then change the displayed week(WEEK1-WEEK52, Displayed month (JAN-DEC), displayed quarter (Q1-Q4) determined by the current date, and display year to date always.


Does this make sense?

Thanks in advance!