I have two macro enabled excels how to compare data on that

i have two macro enabled excels how to compare data on that

i need to append the data that is in excel one has more data then excel 2 after getting the extra data in excelone i need to append all the extra data in excel2 both excel has multiple pages