VLOOK UP and = to help

[jonesa]

I am trying to create this on call rota see attached sheet 1 is what the data retrival from will look like however I am trying to link the data validation drop down box up so that i can select th next site and the report will change on sheet 1 to show the data behind the tab labled 1st july.

2ndly i have another sheet set up for 6th of july on sheet one i want to be able to select the site then the week/date and have the data validation work. is this possible.

Basicaly one search form for multiple weeks and multiple sites that will be duplicated on each weekley tab.

just trying test data at the moment but there will be 61 sites in total over a 4 0r 5 week period. one i have ironed out the issues.

Also is it possible to have the week commecing date linked to the sheet name so if if i change the week I want to look at the date auto changes.

Hope I have explained myself properly hopefully from whay i have produced u might get it.

basicaly i need sheet one to be able to search through all 4/5 tabs show me the dates based on those tabs and pull of the info based on site name and week commencing