I am trying to maintain a single list with:

AdultName Sequence Date Activity ChildName
---------------------------------------------------------
Teacher1 1 9/1 PickUp C1
Teacher1 1 9/3 Teach C2
Teacher1 1 9/5 DropOff C1
Teacher1 2 9/4 PickUp C3
Teacher1 2 9/9 DropOff C3
Teacher2 1 9/2 PickUp C2
Teacher2 1 9/3 Teach C1
Teacher2 1 9/6 DropOff C2
Teacher2 2 9/7 Teach C3
etc

And generate BOTH of the following:

Schedule 1, Sequential activity list by teacher

Seq 1 Seq 2
PickUp Teach Drop Pickup Teach Drop
------ ----- ---- ------ ----- ----

Teacher1 9/1 9/3 9/5 9/4 9/9
C1 C2 C1 C3 C3

Teacher2 9/2 9/3 9/6 9/7
C2 C1 C2 C3


and Schedule 2, Same data sliced into a calendar

9/1 9/2 9/3 9/4 9/5 9/6 9/7 9/9
----------------------------------------------------

PickUp C1 C2 C3

Teach C1 C3
C2

DropOff C1 C2 C3


I was doing this by putting "=cell" into the two schedules, but data is
constantly shifting so it became a maintenance nightmare.

Then I found Pivot Tables. That allowed me to generate exactly what I
want, except it doesn't show me the details... it only shows me a
function such as "count". Then, when I click on the count, it shows the
actual detail of what was counted.

So, I am hoping I can get some help/pointers here. Is it possible to
have PivotTable display the details of the data instead of a count of
the data? Or, if that is just the wrong tool, any other suggestions
that can help me do this in Excel?

I am a somewhat new user to excel, and new to groups, so I appreciate
any pointers if there is a better way I should be searching for this
answer.

Thanks