compare 4 spreadsheets of orders to 1 spreadsheet to find missing orders

“ I have four documents - Fennessey EDI, Fennessey WO, Fennessey Core, D75 HMH and Fennessey IC. These all have dates, order numbers, amounts and school name but are otherwise configured differently. The Master EDI document, WO, Core and D 75 should reflect in Fennessey IC. The Fennessey IC doc may or may not be missing things from Master EDI, Fennessey WO, Fennessey Core or the schools listed in D75HMH may be missing from Fennessey IC. Please run a report of all missing items as well as make sure that the schools listed in D75 have orders in Fennessey IC with date, order number, amount and school name.”