Macro to check if A#:F# on Sheet1 exists in another sheet, if not add to sheet

[EricL89]

Going to try to make this as brief and simple as possible.

My workbook has 3 worksheets, each sheet's data starts at A4, columns are A:F.

I'm trying to make my macro read Sheet1!A4:F4 as a single value, then check if it exists in either Sheet2 or Sheet3 (also A:F, not in a single cell). Essentially, I'm trying to get this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]Timmy[/TD]
[TD]Thomas[/TD]
[TD]Client[/TD]
[TD]Single[/TD]
[TD]Phone[/TD]
[TD]831-555-4321[/TD]
[/TR]
</tbody>[/TABLE]

To read the value of A:F as a single value, something like: "Timmy Thomas Client Single Phone 831-555-4321".

If it's not on either sheet, copy A4:F4 then paste it in the next available row on Sheet2. If Sheet1!A4:F4 is found in either Sheet2 or Sheet3, go to Sheet1!A5:F5, and so on until the last row of the data in Sheet1. The last row on each sheet will always be different, not at a predetermined row.

I'm sure this could be accomplished without macros, but this is one part of a larger macro. I appreciate any help you can offer! Thanks!