Show employee data from another sheet for current month

Hi,

I have a work schedule and I want to show everyone coming in and out for the month.

On sheet 'fly days' it shows employee name, site, # of days, in/out bound fly days and start of rotation. I want to have the in/out bound and site shown for each employee on sheet 'month view' in order by date. I need some direction on how to do this.

I've attached a sample of the workbook.

Thanks in advance,

Applicable formulas are, for Inbound fly day (columns A:C)

	A	B	C
3	=IF($C4="N/A","N/A",INDEX('Fly Days'!$A$2:$A$1000,MATCH($C4,INDEX('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000,0),0)))	=IF($C4="N/A","N/A",INDEX('Fly Days'!$C$2:$C$1000,MATCH($C4,INDEX('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000,0),0)))	=IFERROR(LARGE(INDEX(('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000)*('Fly Days'!$F$2:$F$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$F$2:$F$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)),0),SUMPRODUCT(('Fly Days'!$F$2:$F$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$F$2:$F$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)))-ROW(A1)+1),"N/A")

For Outbound fly day (columns E:G)

	E	F	G
3	=IF($G4="N/A","N/A",INDEX('Fly Days'!$A$2:$A$1000,MATCH($G4,INDEX('Fly Days'!$I$2:$I$1000+ROW('Fly Days'!$I$2:$I$1000)/10000,0),0)))	=IF($G4="N/A","N/A",INDEX('Fly Days'!$C$2:$C$1000,MATCH($G4,INDEX('Fly Days'!$I$2:$I$1000+ROW('Fly Days'!$I$2:$I$1000)/10000,0),0)))	=IFERROR(LARGE(INDEX(('Fly Days'!$I$2:$I$1000+ROW('Fly Days'!$I$2:$I$1000)/10000)*('Fly Days'!$I$2:$I$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$I$2:$I$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)),0),SUMPRODUCT(('Fly Days'!$I$2:$I$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$I$2:$I$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)))-ROW(E1)+1),"N/A")

Or see attached. Note, I've put in some dummy entries to test.

That worked perfectly. Thank you very much!!