Training scheduling

I’m trying to streamline my ability to forecast completion of training events. I’ve attached a sample of what I’ve been using with manual inputs. The “codes” tab has all of the “events” that are assigned. I’m limited to 3 total events a day, with 4 people being the max amount of personnel assigned to one event (2 instructors and 2 students). They way I’ve been assigning events is by color coding the number, so everyone with the color red is on the same event for that day. Students will have an “X” at the end of their event number. A couple other constraints are that the numbers have to go in the order as laid out on the codes tab (starting from 2002 going to 3303), and ideally there’s at least one business day in between each event for every student. What is not captured that well in the sample is time off from appointments or leave- I just filled those cells black with a space so they weren’t “empty.” Ideally would like to have a template for now into the next 6 months at least

If there’s any way to automate any of this stuff it would be very helpful… things change on a daily basis and it causes me to have to change multiple entries from “today” into months from now. I would have to still manually input instructor/student unavailability as that cannot always be predicted but if there is a way for the script/macros/formula to read around manually blocked off cells it might help meet the intent