Macro needed to copy selected cell data from one sheet to another sheet selcted cell

Hi there,

Would really appreciate if somebody could find a solution to my problem. I am trying to make a shift change/exchange request file for my employees.

The employee would use this file to put in there shift change request from Morning to Evening or from Night to Morning (any) for a specific date or date range.

As soon as the employee clicks submit, the data should be transferred to second sheet (in this case: Only to be seen by Admin) to the specified cells, and the request entry should get deleted from the first sheet (in this case Request Sheet) for fresh entries.

Need this data for a total of 100 employees and as and when the request is put forward, what the macro should be able to do is

a) pick Employee Code from (request sheet)
b) match the same on the sheet (Only to be seen by admin)
c) once it matches the criteria come back to (request sheet) - pick date against the column change/exchange requested from to) and paste the data in required cell in sheet (only to be seen by admin)
d) comes back to sheet (request sheet) pick the employee name and with whom exchange has been requested for. (if cell left blank) puts (-) in appropriate cell in sheet (only to be seen by admin)

Hope i was able to explain. For easy navigation and understanding, I am attaching herewith the file in discussion.

please help