how can I pull data from one sheet into another using a macro

[techcurious]

Hi. I am brand new to using macros in Excel 2010 and would appreciate some tips. I am looking to have students scan their bar codes into an Excel form which automatically pulls the name associated with that bar code number and then adds a time and date stamp for in/out. I found a script that seems like it would do the job (http://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out-3.html), but being new I don't think I have it set up correctly. I have pasted the code into a sheet and then a list of all student numbers with last names and first names, but when I click on the A2 cell, I can scan the bar code and it will add the time and date, but the number will not change to a name; infact it doesn't matter what number I scan, it will still place it there and just add the time.

I have attached a screen shot for reference. Many thanks in advance for your help.

Excel 2010

	A	B	C	D
1	123456	TEST	MICHAEL	10
2	223456	ABBOUD	GREGORY	12
3	323456	ABEL	GILLIAN	11

<tbody>
</tbody>

Student IDs​

Excel 2010

	A	B	C	D
1	Name		Time In	Time Out
2	123456		9/6/2013 8:46	9/6/2013 8:46
3	223456		9/6/2013 8:46
4	9999		9/6/2013 8:46

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Attendance​