I have two worksheet contain same customer's name in column B, but they might
be in different row, how can I make sure they are in same row between two
worksheet, also when I add new customer's name by inserting row in worksheet
one, how can it be added to worksheet two in the same row so that they are
always consistent?

Thanks a great!!

Hank