Matching Patient Personal Data To That Already Stored In A Database

I am trying to write a macro to transfer patient personal data onto a database.

On sheet 1 the user inputs the patient surname, forename, date of birth, date of test and the test results.

On sheet 2 is the database, where patient surname, forename and date of birth is stored in columns A, B and C respectively. The remainder of the columns on each row is available for scoring test results.

What I would like the macro to do is as follows:
•Read the patient surname as input on sheet 1
•Check on sheet 2 if that surname already exists
•If it does, check if the forename and date of birth also match to sheet 1 for that particular entry.
•If a match is found then copy the test results into a column on that particular row. E.g. could be copied into column D.
•If no match is found, then all the data is entered as a new row on the database (I’ve written the code for this bit but thought I should add it in for clarity)

This will then allow all test results for a particular patient to be read off the same row in the database.