Thank you very much for the response. It is doing exactly what it needs to except that the individual days events need to be in time order on the master (regardless of what unit/department is doing it). In the example, events go 0800, 1000, 0830, 1030. They should be 0800, 0830, 1000, 1030. Also, in your script, you removed the merged date cells. Is there any way to remerge them again in the master?

Thanks again for your help. I would have never been able to get this far in the time allotted for completion.