Trying to create a rotation schedule

So for the life of me and after a ton of research I am unable to figure out how to create a simple self populating job schedule. I'm trying to create a table with job titles on the left, going down the first column and then the rotation going across the top row. 10 jobs, 5 rotations. Basically I would need it to fill in who does what job each rotation with nothing repeating through out meaning two people wont be doing the same job a rotation and someone wont be doing the same job twice. Would also need to easily be able to remove people who are absent for the day and not every team member knows all the jobs. I would like to create a table with team members names and jobs they know, 1-10 and just self populate a schedule every day.

Start off by making a sample workbook showing what you are trying to achieve.

Attach it showing your required output.

Go Advanced _> Manage Attachments -> Upload

alright I think I uploaded it correctly