I have 2 staff members filling in their own individual worksheets.

I want a master worksheet (or book) that pulls in the info they complete in
their rows. For example:

- John inputs a customer's name in his worksheet Cell A2.
- Jane inputs a customer's name in her worksheet Cell A2.
- I want a worksheet that doesn't merge their info together but displays
both. For example, my cells A2 and A3 will contain the info from their rows.


Is there a formula I can use to do this?