I am trying to create a summary page based on several following pages which are all in exactly the same format, and I want only specified cells from each page (of course)
I have set up the first line using page references, e.g. Page1!E45, plus many more cells from the same page.
Now I want to copy that line (many times) to create references like Page2!E45, Page3!E45 etc. Even if all the cells were correct but I had to change the page reference, that would be better than having to enter everything for each line
I think this should be possible, but can no longer remember how to do it.
Thanks
