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!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee #[/TD]
[TD]Employee Name[/TD]
[TD]Position[/TD]
[TD]Location[/TD]
[TD]Shift Start Time[/TD]
[TD]Call Out Time[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John Doe[/TD]
[TD]Worker[/TD]
[TD]Office[/TD]
[TD]4PM[/TD]
[TD]11AM[/TD]
[/TR]
</tbody>[/TABLE]

• 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.