Ok this one, in my mind is complex. I'm hoping someone can tell me I'm wrong.

Creating a weekly schedule breaking out each Day as its own sheet with at least 30 users listed.

1. Each sheet has 15 min increments for scheduling
2. Each cell within those 15 min increments has a letter associated to it
3. Each letter signify's something that needs to be read
4. Timeframe is 24 hour days

What I am trying to do:
1. I used Data Validation to make a listing of names for those on the schedule
2. I've made a simple table, each line is a day representing that tab
3. I would like to provide a simple view to those scheduled
4. The below table can be changed
Day Date Phones Lunch Meetings
Monday 8/6/2018
Tuesday 8/7/2018
Wednesday 8/8/2018
Thursday 8/9/2018
Friday 8/10/2018
Saturday 8/11/2018
Sunday 8/12/2018

1. Those letter's above under breakdown (3), they signify the start/end times for coverage.
1a. They could have breaks in between those times. Example: Shift is 8am-430pm, Letter A is in cells corresponding to 8:00 AM to 10:15 AM and 2:00 PM to 3:30 PM. I want to show the start and end times for each breakdown

Person 8:00 AM 8:15 AM 8:30 AM 8:45 AM 9:00 AM 9:15 AM 9:30 AM 9:45 AM 10:00 AM 10:15 AM 10:30 AM 10:45 AM 11:00 AM 11:15 AM 11:30 AM 11:45 AM 12:00 PM 12:15 PM 12:30 PM 12:45 PM 1:00 PM 1:15 PM 1:30 PM 1:45 PM 2:00 PM 2:15 PM 2:30 PM 2:45 PM 3:00 PM 3:15 PM 3:30 PM 3:45 PM 4:00 PM 4:15 PM 4:30 PM
John Smith A A A A A A A A A L L L L A A A A A A
Jane Smith B B B B B B B B B M M L L L L D D D D D D D D