Hi i have a problem - i have multiple cells in multiple work books all updating a main worksheet - this is using the simple "= " then click on the cell function

They all update fine, until i move a worksheet or rename one or move the master folder of that sheet.

Does anyone know how to keep the link live when you move or rename the child files????

Please advise

Thanks

Paddy