VBA to collect data

Hi, I have 2 sheets attached. The sheet 4th Floor contains desk locations, the second sheet contains connectivity information. I am trying to write a macro that will take the first location at cell A2, it will then search through column A of the second sheet connectivity. Whenever it comes across a matching entry it will transfer "IP Address", "Hostname" and "Mac Address" into the fields in the 4th floor sheet. In some instances there are more than one instance of the location in the connectivity sheet, this will need a new row inserting in the 4th floor sheet beneath the first one and the same information transferred. If there is no record for a 4th floor location "No Value" should be returned to the IP Address" field.

Thanks in advance.