Auto complete data


This is my query:
I have a spreadsheet “A” which would be where the App would be made and in spreadsheet “B” would be the auto-fill data
Could you tell me what is the option for the data to be completed from the input of information? for example: if I scan a QR code of a worker, the name and surname appear automatically in a next box, then the address and so on other information that I need.

Thanks in advance for your reply