Shift activity tracker for years.

Hey guys,

I was assigned at work to create a spreadsheet that will track activities. Idea is quite simple, but whatever I do, I think it can be made simpler and more effective + I don't really have ideas how to put it all through for a summary for coming years.

I created a single tab for each week of the year. Now the question is: should I create 52 spreadsheets per year? Or maybe only 12, each one containing 4 or 5 weeks depending on period of the year.

And after that follows connecting the spreadsheets into one big summary. I know how to link cells between spreadsheets but I'm afraid that the each year you will have to adjust cells manually - Is there an easy way to create a web of spreadsheets?

Also, please take a look at the formulas, I have a feeling that it can be done in a easier way.

If any of this makes any sense - please grab a look and share ideas

Regards,
Al.