Pivot tables over two worksheets

Hi,
I have two spreadsheets one which contains arrivals information and the other Departures as attached.

I would like to draw information from both spreadsheet, for example to find all guests arriving on 07/02 prior to 14:00 and all guests that are leaving on that same day.

Could I use a pivot table which searches information across two spreadsheets, if not could you suggest another alternative to draw this information?

Many Thanks
Colin