Google Sync with Calendar and Sheets -- 2

Background: Currently I have a script which updates google sheets and calendar upon edit. However, sometimes it does not do the job especially when entries are updated via copy and paste. Attached is a screenshot of what the google sheets look like where each column represents a room with its own google calendar. And each tab represents each month of the calendar. I would like to have a separate script that includes the following: 1. Routine to run every "X" period that updates google sheets entry to the calendar. SO if one entry is empty the routine will keep the entry on the calendar empty or delete an existing one. 2. Entries that are populated on google sheets by formula will also be populated. e.g. cell 1 ="cell 2 Or Cell 3" => Cell 1 will be updated on the calendar .