How to Compare Data Across Multiple Worksheets

Hi All,

I have a workbook with four separate worksheets. The data that comprises these worksheets is almost identical, but I know there are a few irregularities that exist between them and that's what I need to find out.

ExcelHelp.png

The 'X's are what denote a particular type of wildlife inhabiting a certain state park. The data on each of these worksheets is very similar, but some worksheets will have an 'X' in a cell where other worksheets do not. That is what I'm trying to figure out (the actual worksheets have hundreds of different rows).

Also, to make things slightly more complicated, column 1's values also differ a little over each individual worksheet. (One worksheet may have a 'State Park 3', whereas the other 3 worksheets don't).

What is the best way to gather and summarize this data?

Thanks for your help (using MS Office 2010 if that helps)

Please check the link and hope will help you:
http://www.paininthetech.co.nz/?p=1246