how do i merge excel spreadsheets and can out eliminate duplicate entries and if so how

thanks