INDEX/MATCH functions

Ok here's what I am trying to accomplish.

I have a workbook with 3 sheets.

Sheet 1 is like this:

Airline_Name	Flight_No	Flight_Time	City
US Airways	2945	         1:57 AM	 LAS VEGAS

Sheet 2 is client data and I would like to input into a cell the Flight_No from Sheet 1 and have the next cells auto fill the info for Airline_Name, Flight_Time and City. This will done for arrivals and departures.

I've seen some formulas and code to auto fill in cells but nothing that quite matches what I'm trying to accomplish. Is this to big of a task for Excel?

I've attached the file for anyone that wants to see what it's like so far.