Transfer info from one sheet to another... need help with Macro

Good day everyone,

I have this project where I need to be able to transfer specific info from a row to another sheet using a specific roster number. I have attached the worksheet for reference.

Is it possible to create a code where just typing the roster number from the primary sheet (Roster, in this case) on another sheet will cause the info from the primary to copy itself to the new sheet? I just need the info on A, C, D, E, and F to transfer over.

I hope I expressed this clearly and appreciate any and all help on this matter.

RO ROSTER.xlsx