How to make a weekly reporting tool with sharepoint list

Hi all

I received to create a reporting tool either with Excel or on Sharepoint. Every week a fix number of departments have to report on a couple of fixed topics with fix answers Yes/No or a number 10%, 20%... Each month this data will be assessed for progress and built some charts, bar or wathever. For one week this is a 2 dimension sheet. I call this Table weekly_report_#week:

Departement ABCDED

Question 1

Question 2

...

How would you do this? Cool would be the follwoing idea but I don't know how to do this. Every week an empty list is provided. Short before preparing the new empty list for the next week, people can update the current list. On due date the following happens: The current weeks list gets a date stamp and is attached to the  list of the week before. This gives me a chain of blocks

weekly_report_#week1

weekly_report_#week2

weekly_report_#week3

Every month then like in a pivot chart, four weeks are analyzed and shown in charts to show progres.

Is this possible automatically of course :-)

Best regards,

Daniel