Multiple values

[Dicegoddess]

I have a list of employees and their scheduled start times. I need to take that paticular master list and break it down into another spread sheet by their assignmet, name, start time and each shift having their own column.
Example:Master List
Friday Saturday etc.....
Employee Name Start Time
Bunny B 0900
Doe J 0900
Duck D 1600
Mouse M 0900
Fudd E 1900

Results needed in another sheet:
Days Swing
Assingment Employee Start Assingment Employee Start
SH106 Doe J 9 MB Duck D 1600
SH102 Bunny B 9 Sh201 Fudd E 1900
LI101 Mouse M 9

I want it to automatically update to the other sheet when the master sheet is revised. Im unable to index this from smallest to largest on results sheet. Do I need some type of IF statements?

Thank you, In advance