Formula/VBA that will auto populate information in Sheet 2 based on what is entered in Sheet 1?

[booleanboolean]

I'll try to break this down as simple as possible!

Employee #	Employee Name	Position	Location	Shift Start Time	Call Out Time
123	John Doe	Worker	Office	4PM	11AM

<tbody>
</tbody>

• This is information that I enter in Sheet 1: I enter in the employee number, it populates the employee's name, position, and location. Shift Start Time and Call Out Time I manually select from a drop-down list while I am talking to the employee who is calling out for their shift.

Employee #:
Employee Name:
Position:
Location:
Shift Start Time:
Call Out Time:

• This is what I have in Sheet 2: Essentially, by entering information in Sheet 1, I want the above to auto-populate based on what I entered in there.

Essentially, I could just have these cells equal the respective slots, but the problem I run into is that this file is a CALL LOG, and I am constantly entering in information every call from an employee I get. I want something that, whichever row I am in Sheet 1, to auto populate that information in Sheet 2 , so on and so forth, so it needs to account for how dynamic this process is.

Afterwards, I would like the information in Sheet 2, to disappear once I move on to the next call I get for an employee with new information I then have to fill out in Sheet 1.

Any help would be GREATLY appreciated! Hopefully there is a way to do this.

 

[My Aswer Is This]

All I really need to know is where is the data you want copied and where do you want it copied to.

I really do not need to know what the headers are.