How to merge multiple spreadsheets and remove duplicates

I have at least three spreadsheets (that can be formatted identically) that I wish to merge into one spreadsheet file with all duplicates removed (there will be at least some). The number of lines will be up to about 14,500.

Any suggestions? I am completely new to working with spreadsheets of any kind and have never used Excel.

Thank you.