Tough problem with rotas

[Scott Cheesman]

i have a weekly roster of 35 staff members in the following forma
................A.....................B...................C.................D...................E
1............<<merged cells -
Heading>>................................................
2....................................11th.............12th...............13th..............14th.........'text entries to show dat
3...........Name...............Friday............Saturday.......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