Compare workbooks

How could I performe a comparison of the content of 2 workbooks. To locate
which new records that are added or deleted.

I don't think this could be done directly.
You can use the share workbook option in the tools menu to share the
workbook and then look into workbook history to know the changes made