I have a workbook with two worksheets.

In the first worksheet, I have one column with about 4000 unique
entries.

In the second worksheet, I have another column with about 40,000
entries. For each cell  in the 1st column, the corresponding cell has
a row  of data.

I am looking for a macro  to match the entries from the column from
the first worksheet with the first column from the second worksheet.

If there is a match, then copy the entire row from the second
worksheet to a new worksheet.