This is somewhat of a follow on from my post yesterday about changing many
references at a time. Using a name variable in my formulae and changing the
range set for the name is useful, but I now need to change a whole load of
references in existing formulae.

I have a workbook with many sheets that have I've collated together. The
problem is each sheet contains a referenced array that it is common to all
sheets. This array is pretty big, and has some pretty complex formulae in it.
However, because it appears on every sheet, my file is getting pretty big,
and I need to cut it down.

I want to copy the referenced array to a master sheet, delete each occurance
from all the other sheets, and change the cell references on each sheet to
point to the new 'master array sheet', hopefully without upsetting any of the
formulae.

Any takers??