How to make automatic substitution of data from another sheet in Excel?

Question

excel

For example, I have tables on several sheets with columns: "Date, Surname, First Name, Patronymic, work experience." Each sheet corresponds to its department at work.
And there is a general sheet where there are the same columns: "Date, Surname, First Name, Patronymic, work experience", but on this sheet absolutely all employees of all departments.

How to make it so that, for example, when entering the last name of an employee on one sheet in the "Last Name" column, the data is automatically pulled into the "date, first name, patronymic, etc." columns from the sheet with a list of all employees?

Answer 1

VLOOKUP function.
PS Don't forget about namesakes.