Synchronising cells using VBA

Hi All,

I'm looking to use a code to synchronise several cells on two different sheets within a spreadsheet. I have used a code in the past where one cell linked to another by VLOOKUP, and vice versa using VBA so as to not create a circular reference.

In this instance however I want to be able to type text into each cell that link to each other using VBA. To further complicate matters, the data in the "Site Data" tab will need to change depending on the site dropdown list, as it would with a VLOOKUP function. And to add to all of this, there will be sites added continuously to the "Costs Tracker" tab (i.e. a new row added to the bottom of the table), and I would like for this data to automatically link to the "Site Data" tab when selected from the dropdown list.

I have attached a copy of the spreadsheet. The two tabs in question are "Cost Tracker", and "Data Sheet". In the data sheet tab I have written the relative cell name from the "Cost Tracker" tab that I would like the cell to synchronise with (obviously C4 for example would change to C5 / C6 if the site is changed from the dropdown list). Sorry if I haven't explained myself very well, I'm new to using VBA, so not sure if this is simple or more complex to achieve. I'm not necessarily looking for someone to write the the entire code, but if someone could point me in the right direction it would be much appreciated.

I'm sure there will be some important info that I have failed to mention, so if I need to clarify anything, let me know.

Thanks in advance.

Aidan