Hi, I have what I think is a simple problem, but I have been trying for days to solve it, to no avail.

I have a series of sheets that are all identical in that they are calculators to estimate building work
When a calculation is done, I copy the description and price onto a master sheet. The price cell links to A1 on its own sheet so that when I paste it into the master sheet I am able to click on the price and it will return me to the appropriate calculation sheet

The problem arises when I duplicate the calculator sheet. On the new sheet, the link to A1 works fine, but when pasted into a master sheet, the link takes me back to the sheet I used to make the duplicate from, rather than the duplicated sheet itself.

I have made a very simple 3 sheet workbook to better explain which is attached

Any help appreciated