Is there any single, unique identifying piece of information that would be
found in all sheets such as the tax bill number? Or would even those
possibly be different (or even missing) for the same piece of property on
either the same sheet or on another sheet?

"Ivan" wrote:

I have approximately 2500 properties (address number, street name and tax
bill number) and 25 sheets (each representing a different property
developer). I need to determine if the same property has been allocated to
more than one developer, that is whether an entry is repeated on more than
one sheet or even the same sheet.

I would also like to calculate exactly how many entries are in the entire
workbook.

Thanks,
Ivan