Lookup values in one cell, if they match copy content of another cell to different sheet

Hi All,

Basically as the title says I need a VBA Macro to Lookup values in one cell, if they match copy content of another cell to different sheet.

Basically I will have a sheet (Will be more in depth) that will list names & credits what I need is a macro that checks if the "Agent Name" is on the "Agent" Sheet if it is then I would like it to copy the value from the "Credit" cell next to the name I have uploaded an en example.

Thanks