I have a spreadsheet emailed to me on a fairly regular basis. I need to
change the layout of this and have written another sheet which points to the
relevant cells and inserts the data into my sheet. This is fine until I open
the sheet again, when I'm prompted to renew the links.

Can I somehow read the data from the emailed spreadshhet once, then break
the link so that th new sheet is standalone?