comparing column in multiple spread sheets

Hi-

I am trying to  compare a column that exists in multiple sheets to see were a discrepency exists .  My main source is all Machines in  Active Directory.   My other 4 sheeets are different apps we use that should have agents on them,  In short I am looking for what machines are missing aents I want to run this on a weekly basis.  what's the best way to do this?