UDF in excel to use a dropdown list in a sheet, to push data to other sheet.

Hi all, I have a very basic knowlege of excel, and I despriately need help.

I have created a workbook, in the work book I have a master job register sheet and a sales sheet for each sales rep,

I want to populate the sales reps sheets based on data entered in the Master Job sheet.
I want to do this automaticly when the rep is select from a dropdown list.

Is this possible?

See attached images below