return several values based on cell value

Hello,

I'm trying to build a sheet that will return several times based on the cell value. The example I uploaded: the main data I'll pull is on the tab titled "flt info". This has the gate number and time the aircraft arrived and departed throughout the day. The number of flights will be variable depending on the day.

I'm trying get the tab titled "gates" to poplulate the aircraft arrival & dept times based on the gate number.

I've added it manually just to show on the "gates" tab how I want it to look.

I've been playing around with index and vlookup but can't seem to figure it out. Any help is appreciated!