Hi Tony
You have helped me on a first incarnation of this project which has linked data and formulas.
I've only included the first 2 columns for the test, the working document I want to add this to has additional data from cols D onwards.
In reality to save having to move significant amounts of data from specific rows and other linked pages, it's the room numbers that need to change