Help with Referencing Ranges

Hello,

Attached is my excel sheet I need help on. The "All" tab is where I want the data to go. Under the "Location" heading, I want to display the sites name, under the "In'" and "Out headings, I want to display the times they are in and out. What I am trying to do is make it so the cells show when and where each employee is working. Therefore, the "All" sheet should so Frank working at Site 1 on Monday from 0800-1600 (go to the "Site 1" tab and you'll see frank's hours for that site) and Tim working Site 2 on Thursday from 1600-0000. I want the formula to go across all sheets, therefore it will display the exact days Tim is working, at which site, and what time. I have a total of 18 sheets, but if you can just do these two I can see the pattern taking place.