I am dealing with multiple worksheets (about 15) there is data that spans all of the worksheets.

At present I have the pages set with a relationship so that A2 on worksheet 'survey' pulls the name of a facility from the 'location' worksheet column c using a drop down box.

I would like to be able to centralize the information from one cell on worksheet 'Site' to 'location information'.

I need the data to be available on one sheets, and when it is available on one sheet is updates the other. Any change to Survey 'A23' will make changes to the cell.

I have this formula right now to tie the cells together with the facility. is there a way to change this code to allow this?