Search for text in table (all columns/rows) and return date/text (Match, Index, VLookup, Filter - HELP!)

Question

I've been driving myslef cracy trying to work this out - which at first appearances seems quite simple. I have a table containing sites at which different surveyors are working on at different dates and times (dusk or dawn). What I've been trying to do is search through all the sites for each person and generate a Table similar to the one below:

Summary Table

My data is laid out like this (Sheet 1):

Basic data

and i have been using a separate sheet as the search text (Sheet 2, Column "Site):

enter image description here

I have tried a pivot table, the VLookup but it woudln't serahc for multiple text items and then i tried messing about using MATCH, INDIRECT and INDEX functions. I almost got this to work but MATCH didn't find the text even though it was pointing at the correct column.

I'd be happy with any convoluted way of doing it - just to out me out of my misery! Many thanks! Jon