Display daily shift from monthly schedule on another sheet

Hello,

I have a monthly schedule for a medical dept. Every day I have to fill out a daily assignment sheet (for the operating room), and what I have been doing is looking at the day column and manually sorting out which staff is on which shift and writing it out on a template. I'd like the ability to sort have excel sort all of the different shifts by column and then add the employees who are assigned to those shifts to be added under the shift column header. Is there an easy way to do this? I have attached a practice sheet.

It would help if your daily schedule related to a particular day within the Monthly Schedule sheet, so that we could see what data you wanted to display and where to get it from. Can you re-post your file and choose one day and show the results you would expect to have doing it manually.

Pete

Alright, will do. Basically, for now I would just like some columns that have are headed by the shifts and the employees assigned to those shifts. Right now, looking down a giant column is annoying. Also, eventually I'd like to be able to popluate a template that could be printed, which I showed on the 3rd tab labeled "Daily Schedule". That looks more complicated thought. Tried to figure out if I could use Vlookup, but I don't understand that formula yet. This file will have the day I want sorted in light blue.

This schedule is a legacy design that we've had for years. There's all kinds of old merged cells, and could definitely use a tune up to make it easier. I'm open to doing a brand new schedule.