Tough problem with rotas
 

i have a weekly roster of 35 staff members in the following format
................A.....................B........... ........C.................D...................E
1............<<merged cells -
Heading......................................... ........
2....................................11th......... ....12th...............13th..............14th..... ....'text entries to show date
3...........Name...............Friday............S aturday.......Sunday..........Monday....'text entries of the day
4...........Staff 1............10:30 - 5:00...........................12 -
11..........5:15 - 12...'text entries showing when they're working
5...........Staff 2...................................5:15 -
12.............................12 - 11.....

what i'ld like to do is automatically generate two new sheets for each day
of the week listing the staff member and times that they're working - the
first sheet will be for morning people (shifts begining at 10:30), the second
sheet for afternoon people, (shifts beginning at either 5.15 or 12)

any ideas?

thanks in advance

scott