I have one worksheet. One sheet has data in the following fashion
03/01
OFFICER - in - out - MANUAL
Agent1 14 15 30
Agent2 21 16 13

03/02
OFFICER - in - out - MANUAL
Agent1 14 15 30
Agent2 21 16 13

I want to use this data in a second sheet as follows:
Agent1 03/01 03/02
In 14 14
Out 21 21

How do can I reference my cells in the 2nd worksheet so that I can just drag
the cell across March?

Thanks,
EddieV