Shift Schedule - 3 Shift Coverage - Auto Populate Roll-up Summary Schedule

[chips1256]

I've got a schedule that shows all 3 shift, 7 days/week. It includes vacation as well. I need to have this detailed schedule auto-populate on a summary view of the week to show who's on what shift and who's on vacation. Ideally I want this to update automatically each Monday at 12am to show that weeks schedule. I have been playing around with the INDEX, MATCH, SMALL, and ROW functions but I just can't quite get it. Any help would be greatly appreciated!!