Dropdown boxes not updating cells

Hi Everyone,

I am somewhat knowledgeable in the use of Excel but not so much when it comes to using formulas etc. I have figured out through trial and error how to use VLOOKUP etc.

My issue in this case is, I have the following:

Sheet2 - Contains all the raw data
Sheet1 - Contains the same information only using multiple VLOOKUPs to pull in the data from Sheet2.
REPORT - The is meant to be the front cover of a contract which has a dropdown list containing facility names. Below this, I have a number of cells containing the information which relates to the 'facility/facilities' in the dropdown box. The cells all have VLOOKUP formulas that fetch the information from Sheet1.

My main issue is however, when I select a different facility, the appropriate cells don't change their values to match the facility.
If I change any values on Sheet2, the change is reflected in Sheet1. But how can I do the same on the REPORT page when I select a different value from the dropdown box? It should do exactly the same as Sheet1 and Sheet2 but I'm not sure how I can do this?

Can anyone help me?
Thank You