How to create a Academic Yearly Event Planner for an Organization

Hello,

My problem is that my organization has several events every year. each event has certain tasks to be completed to prepare for the events and these tasks are listed per event in seperate sheets in the excel file. in the first sheet i need a template list of calendar days for the year listed in weeks (week 1, 2, 3 etc.) with drop downs showing the days in that week. and my next this is the ability to so show all items from all sheets that have a Week one task in a master sheet. Is this possible?

Here is an example

example.xlsx