Pulling specific data to create reports from large data spreadsheet

I have a report that I use one spreadsheet that tracks all activity of interview candidates. Management wants me to give them specific data from this report. I need to create away that I can pull separate data for Offers extended, offers accepted and start date. Each report needs to show the name, position and state.
I thought a lookup function would would and just have separate worksheets but I couldn't get that to work.