Combine data in three separate data sources

Hi I have three separate excel files, with some duplicated columns and some unique; the rows may appear in one, two or all three files (in total there are >200 rows / about 80 are unique).  For refe...