I would like to set up alerts on calendar events from a few calendars. There are 4 calendars on our site (conference room, board room, etc.). They get events thrown in by everyone in the company. I'd like to set up a filter or search to find 3 or 4 key words and alert my department's email address 30 min before the event takes place (I don't care when the events are created, we just need a heads up on them happening).
Would the most simple solution be to create one more calendar that pulls from the others, or use RSS, subscription, workflows, or some sort of custom web part list and add alerts to those?. I don't want to rely on those who create the events to always add us.