I want to type a name in one cell on a worksheet and have it appear in
another worksheet. Basically, type one text entry and you get two - one in
one worksheet and one an another.

Any suggestions?