Hello,
I hope I explain this correctly. I have a xls file with (sheet 1) with all
my names and addresses. I have employees that will handle different
territories so I need to copy certain portions of (sheet 1) to other sheets
in the same workbook. What I would like it to do, is (sheet 1) is the main
with master list of addresses. I will name each of the following sheets my
emplyees names. What would be great, is that on the main sheet, column "A"
is where I would enter my employees name for whatever address I want to
attach to their sheet, and it would automatically copy the address row to
their sheet. Automatically would be great, so I do not have to each time run
the macro, once name is entered it it copied. hopefully this is possible.

I have included a link that may better explain what I am trying to
accomplish.

http://65.18.128.108/2.2/catalog/images/ebay/excel.htm

Thanks for the help,
JR