Excel Planner

I require someone to create a yearly planner within Excel. We have 5 departments who will each enter information (via a form perhaps) and this information will show on each department planner. There will be a main planner that will show only priority 1? events from each department? (the priority will input when the event is initially entered onto the form). We will be able to scroll through the planner from month to month and as we do the information on it will update, we don't mind whether this is done with formula or vba. Further information and diagrams can be provided if required. ## Deliverables In the [login to view URL] file I have attached this is what we want the planners to look like. How the information is input we are open to suggestions.