Hi BLM;

Jan Karel Pieters's Name Manager add-in, freely downloadable at:

http://www.jkp-ads.com/Download.htm

Might well reduce a lot of the manipulation pain - and it is well worth
having anyway!

---
Regards,
Norman



"BLM" wrote in message
...
Hi,
I have several worksheets which contain the same names but different info.
I want to be able to add and delete names in one source file which will
update the
other worksheets, sort in alphabetical order and keep the same data in all
the worksheets linked to the right name.
Thanks