Sorry if this is posted twice-

I would like to have data from one cell get sent to another cell in the same
worksheet. But I don't want to put a formula in the second cell to grab that
data from the first cell. Is this possible?

For example, if I type in my first name in A1, I would like it to
automatically appear in cells A2, A3, and A4. However, I would like to have
the flexibility to type in my last name into A3 and have that then
automatically appear in A4 as well.

Thanks for your time,
Maria