I need a macro for updating database that works like this:

Sheet 1:
Criteria cell = A2 (name of candidates and it varies all the time)
New Data cell = B2, C2, D2 ...


-Find match cell to Sheet 1 A2 in Sheet 2 Column A
-Go to the adjacent cell of matching cell of Sheet 2 and paste the New Data in across columns B, C, D ...
(only when adjacent cells are empty)
(If adjacent cells are not empty, paste this new data into the cells that are 1 row below adjacent cell)

Thanks for any help given