Auto-populating data on second sheet

[brew618]

I have an excel document that has a column list of events with the employees who will be working each event in each row in the first sheet while the second sheet is a list of each employee with the events they will be working listed beneath them. Would it be possible to set up a vlookup function or something similar that auto-populates the data in the second sheet using what's typed into the first to cut down on time spent arranging the sheet? Is there a pre-existing software or online program that would solve this issue? A sample is attached.

[FDibbins]

1st I would restucture your input table to just have 3 columns - Date, Description, Name

Then you could probably use a Pivot table, or a formula to pull what you need