Excel for registration

Hello!

I need help in speeding up the process for registration during an event.

Basically I have several spreadsheets with list of guests that will be attending a event. (Will upload a template spreadsheet)
IDENTIFICATION NO. NAME ATTENDING REGISTERED? TIMESTAMP
A1234567B JOHN SMITH YES
A7514812G JAMES BOND NO
A3813120R JACKIE CHAN YES


We have a barcode scanner that is able to read the identification no. and the current method we are using to track the registration is to use CTRL+F, scan the barcode which give the identification no. result, then find all and then go to the registered column to put yes and fill up the timestamp.

However this method can be quite time consuming especially with the no. of guests we are handling.

I have an idea on working around this issue but am not sure if it is workable or how to do it in the first place.

Idea: have another spreadsheet created with the purpose to just scan the barcode.

So all we have to do is to scan the barcode in that sheet, a timestamp will be created, and perhaps vlookup the result such that it will automatically find the guest and mark him as registered with timestamp on the other column. Then to scan the next person, we just have to press down arrow to another empty cell.

e.g. in the registered column, have a formula which states: if identification in ROW A matches any of the cell in scan spreadsheet's row A, input Yes, if not No. And to put a timestamp in the column beside if turn from Yes to No.

Also would it be possible to have a countif for the number of registered guests across all the spreadsheet?

Really hope this idea is feasible and if someone could assist in the creation. Would like to avoid using VBA if possible though as the computer used for registration are quite highly secured that vba tend to not work? due to security issues.