New to programming, need help generating random names for a schedule

Hi, I'm pretty solid with basic Excel functions, but I've been making schedules for a while in Excel and need an easier way to do it. Basically, I have a list of names every few months that goes into an event schedule (around 14 events or so, but I only put in 4 to make it simpler). I'd like to randomize the students completely between all 6 instructors. Preferably I'd fill up the first column (Student 1) of each event with 6 distinct names from the student list, and then any leftover would be randomly distributed into the "student 2" column of that event. (This is to make sure that students get somewhat evenly distributed time with each instructor, and each instructor gets somewhat even days with only one student). In other words, since I have 8 students in this example with 14 slots, I'll have 4 slots unavailable in each event, hopefully for Student 2. I also occasionally need to keep an instructor unavailable for one or both events, so I'd need to know how to leave them out. I could do that manually if needed.

I read a few other posts and am not totally positive where all of this is put into Excel. Thank you for the help!

Thank you for the help. I'm new to macros, so is it that the code has to exist on those other pages? Looking at it, if it makes the project much simpler I can honestly leave out the entire "instructor unavailable" issue and just move people around as needed since it's rare. Would that make it easier? Because I'm a little confused as to how to use it. I'm still looking over it. Thanks again.