Creating an Excel Duty Builder

I work for a delivery company, in my office we have 50 staff, each of these staff know different deliveries which are currently on a skills matrix. I would like to come up with a solution in excel, that would create a weekly duty sheet, based on who knows which delivery and which delivery is their base delivery.

I'd also like it so that if a person is marked as absent, it automatically adjusts accordingly to cover the duties.

Is this possible, and where would you recommend i start with such a project ?

Please Help ?

Thanks