updating cell links
is there a way to make a sheet wide change of links to another sheet? I have a pair of sheets I use with one being a data collection, and the second is used for creating visuals. I then use both sheets repeatedly for client work. -- just copy the sheets to a new area - rename and update the links respectively.
A mass link update allowing me to update all l inks to a new sheet (just want to change the sheet name/location) all the cell specific identifiers are kept the same, such as cell names and numbers.