I have a big worksheet (target) which links to different sources (say file
names A, B, C etc). However the addresses in each source linked to the target
are the same.

I can format the whole target by pasting the source A (say) onto the target
serveral times. Thereafter, need only to change the source link to B, C, D etc

At the moment I can only do it cell by cell, which is extremely tedious. Is
there a quick way to do this change of source names?

Thanks.

zhj23