Linking two sheets in a workbook from a weekly schedule to a daily attendance sheet.

Hey all,

I have a weekly schedule (0309-0315) which I am actually looking to plot them into daily attendance schedules (Daily Attendance Sheet).

Is there a way Which I Could get the spreadsheet to formulate so that it pulls out the names and their schedules, and tabulate based on the Daily Attendance Sheet, earliest start time to latest start time (excluding those on OFF days). I have done up a sample of what I hope the spreadsheet could work out for me.

Hoping an Excel Guru could help me out here! I thank you all in advance!