Return entire rows from multiple sheets into one table

Hello,

I need some help with a search of a workbook. I have a list of staff who work in an overseas office and I have their Name, Job title, DoB, passport number, outbound flight and return flight details. When they change over they always swap with another individual.

Each sheet covers one calendar month and lists everyone in the office and at the bottom any replacement staff due in that month.

What I want to do is on a separate sheet, some how list all staff that are due to arrive and depart in the upcoming two weeks and display all the same info which is on the other sheets (name, flight details, passport no etc)

The best formula I have found so far can return all info from a single row but not over a rolling 14 day period.

The workbook has been created in Excel 2003. I can edit in Excel 2013 but need to make it work in the older version.

Thank you for help.

H

You're far less likely to get effective assistance with this if you upload a sanitized sample file.

Example.xls

Any help would be appreciated. Thank you