Pulling Data from multiple sheets and inserting rows

Hello all,

Brand new here, I wanted to see if my situation was solvable through a VBA or Macro.

I have several sheets of people's information (that I clearly cannot cut and paste here) that I want to try to merge to one sheet.

Say I have 3 people, A,B, and C, all three are on each sheet and appear several times. The sheets are record systems of events occurring and each event has a date associated with it.

I would like to pull the events from each sheet and put them in order by date for each employee:

Person Event Date
A S 1
A P 2
A P 3
A P 4
B S 1
B T 2
C P 1
C P 2
C T 3

Basically a larger merging over several sheets, would this be possible? Feel free to ask anymore clarification questions, I just can't post the actual data.

Thank you!