compare data from several spreadsheets

[Christine]

I have several spreadsheets that I would like to merge into one. Is there
anyway to easily find out which will be duplicates and which will not before
doing a merge?

Any suggestions will be helpful. Thanks.