VBA - Help creating a Macro for a button

Example sheet attached

On Sheet.Entry, i would like to use the drop downs to create a value (which it currently does). when i click the "LOCK" button, i would like the values in column 'A' to be copied to the corresponding "RESPONSE" cell in Sheet.Data.

If this doesn't make sense, i'm sorry. Still learning.

Example:


A
PASS 200 Value 1
PASS 800 Value 2
FAIL 400 Value 3
CnT 20 Value 4
TEST 20 Value 5
PASS 400 Value 6


On the "Data" sheet, it would look like so:

NPC Name Response 1 Response 2 Response 3 Response 4 Response 5 Response 6
1 2 3 4 5 6 7
A PASS PASS FAIL CnT TEST PASS