I am trying to prepare a consolidated events calendar that would have one front page (i.e. main sheet) that would be a calendar. This sheet would contain date of the event and description. Since there are many events, different offices and people, I want to make it easy to track events across the office so the other sheet would contain data points that everyone would have to enter such as event description, status, title, type and date. What I really need is when someone enters the name of the event and its title on the other sheet - that that information comes up on the master calendar.
