Attendance Register

Hi all

I am trying to create an attendance register for weekend trips.

I have the following colums
ID No., Surname, Forname, Gender, NOK, Contact Number

I have 2 sheets one has all the personnel details on and the other is just headings.
What im trying to do is if I enter the ID No. for one person the other colums will automatically add the details for that person.

Can anyone help please

try to read about INDEX / MATCH or VLOOKUP