Search for name in column and paste data row

Hello,
I have a sheet with a list of events and times and individual names associated with those events and times. For example Sheet1: Column A: Type of Training, Column B: Name of individual in that Training, Column C: Date Training Starts, Column D: Time Training Starts, Column E: Date training Ends, Column F: Time Training Ends, Column G: Remarks. So I have several other sheets 2-16 that are for each individual Memeber. I am trying to find a way to do a search in Sheet 1 for one persons name and have it fill in sheet 2 (Individuals Members Sheet) all the events that are associated with that persons name on sheet 1. I don't know which would be easier a formula or a macro. I am not that familiar with Macros but would like whatever will make this filter easier. I have over a hundred different people that I need to filter off this sheet1 and am in need of some serious help. Thanks in advance for whatever advice you can give me!