Update from one sheet the other [Closed]

Report
-
Hello,

I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving systems and I am storing and updating all employee info in Excel - if there anyway I can get excel to automatically update if I have a key bit of information linking the update and the current info?

i.e. if there employee code matches on sheet 1 & sheet two any differing info on sheet 2 will be overwritten on sheet one?

The goal is to fill out of the changing info on sheet to and for it to feed into sheet 1