Compare FOUR Worksheets And Extract Matches?

I have a Workbook containing four different Worksheets, each of which contains a different number of columns:

"Set A" = 18 Columns
"Set B" = 47 Columns
"Set C" = 47 Columns
"Set D" = 11 Columns

Each Worksheet contains a different number of rows, approx 4,000.

Column A for each of the above Worksheets is, however, the same and contains an alphanumeric string called "Accession ID".

I have been tasked with extracting the entire row of data for each "Accession ID" which appears on at least 2 Worksheets, and then compile them in a new "Summary" Worksheet.

So, for example, if one of the Accession IDs was "ABC123" and it appeared on all four of the Worksheets; the Summary Worksheet would contain the 18 Columns from the row on which "ABC123" appeared in "Set A", the 47 Columns from the row on which "ABC123" appeared in "Set B", the 47 Columns from "Set C" and the 11 from "Set D" all on different rows.

I tried toying with VLOOKUPs etc, but given there are four Worksheets, and in order to qualify the Accession ID must only appear on a minimum of two Worksheets - it quickly become a mess.

Is there any way of being able to do this as a macro perhaps?