Thanks Paul,
This is simply where the (for example) destination workbook cell = a cell in the source book. Works fine until it is closed and the source book has a row added to it and then the formula is not updated to recognise the new row and so the two cells no longer reflect each other. Would INDEX solve this?
Regards
Billy