I am trying to get the value in the cell B4 on the sheet FORM in workbook Emergency Log onto sheet FORM cell B4 in workbook Log Summary. Why are we using C4= in the example above?

Also if there is nothing in the cell in the Emergency Log, it should be blank.

When I paste the formula in the cell in the log sheet, it is appearing as text not a formula.

If I have to manually edit each line once this is working, that's OK, I don't mind it as long as it gets the data over.

.