FIND & MATCH - Multiple workbooks & worksheets

Hi guys,

Apologies in advance, i am new to excel and don’t really know what would be the best way to use VBA to get the results.

Need some help with some data matching.

• To compare values of column A in two workbooks (wb1 & wb2)
• If non match then output entire row to a new workbook.
• Loop through all sheets on wb1

So.... In the end there will be 3 workbooks...

• wb1 = original data - multiple sheets
• wb2 = new data, with possible duplicates - one sheet
• wb3 = all unqiue rows

Is this possible? I’ve attached 2 workbooks as examples.. If this is possible, could you direct me in the right direction to get this started?

Thanks in advance ,

wb2.xlsx wb1.xlsx