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

The goal here is to learn, so anyone who would be willing to take the time and show me how this is done, would be greatly apreciated

any ideas?