How to compare 2 or more Excel spread sheets for differences.

We share keeping Excel data up to date on different Windows versions of Excel. We need to combine our data to obtain one valid data sheet. Is there a means to compare and produce a summery of differences and consolidate them?