Scheduling Appointments

Hi,

Can someone derive formulas to post appointments to the Weekly Schedule sheet from the Appointments sheet please?

There needs to be travel time from cell E3 between appointments. I manually entered the appointments with different fill colors showing the duration.

The lunch hour should be designated from the Appointments sheet M1 & M2.

Thanks