Need to copy data from one sheet to another

Hello experts,

I am new to excel, I have a requirement where I have multiple sheets and I need to create a master sheet..based on the surrogate keys from different sheets, for example if I enter the value of surrogate key in the coloumn of master sheet, then remaining fields should get populated automatically. else if the surrogate key's value is incorrect then it should show a color error. Requesting your help.