VLOOK UP and = to help

I will try again.

There will bw 4/5 Sheets labled as wK Commencing depending on How Many weeks are in the Month.

On the search form I require a drop down box that when I select it will display all the site Names from each individual Week.

So for example if i select Leicester from the drop down box, i will then need to select the week. and then the fields on the search form will auto Populate based on the vlook ups.

If you know of an easier way or better design please feel free to show me. spent a week on this already lol but all the field names etc I need to keep.