Excel Format - Formula

Hello, I want to have a chart that is automated so when I selected a date it would look for that day in all of the sheets and find all the employees that work. Then generate a report to show ever hour for when they arrive to work, go to lunch, and leave work. Example is Smith leaves at 2 and Josh arrives at 5 I would like it to show a chart of the hours and under 2PM show that smith is leaving and under 5PM show that Josh is coming in. I did attach a Example File would at lease see a screenshot of what the chart looks like before purchasing.