Hello,
I am new to excel and need help please, I'm trying to compare five workbooks to each other in excel and have matching column data copy the entire rows into a new workbook (ReportWorkBook). Ex:

Compare Workbook_1 column A to Workbook_2 column A to Workbook_3 to Workbook_4 column A to Workbook_5 column A

If there is names matched, copy the entire 5 rows ( one row from each workbook for the same name if match found in all of them) of matching Workbook_1, Workbook_2, Workbook_3, Workbook_4, Workbook_5 data to the new Workbook (ReportWorkBook). Also to make each name data rows separated from others, meaning if there are more than 1 name matched in all of the workbooks, each name data bulk to appear as a separate table.


Any help would be appreciated.
Thanks