I want to track completion of required monthly safety tasks for several departments. I want to be able to record the department/date/event on the page named Event Log and have the recorded date show on the page named Monthly View in the appropriate row and column that corresponds to the department and event. I would also like to be able to select the month to show recorded events. I have attached a workbook with some basic data.

Safety Event Log.xlsx