I need some work on MS Excel & CSV databases

I have a number of database files on Excel.
They are school files, some contain head teachers names, some contain email addresses, all contain school name, address , Tel No and post codes. approx 30,000 records, however you will be working from 70,000 records as some of the fields are duplicated.in the various files

I want to end up with one file that contains all the info, school names, address, tel number, post code, head teachers name, email etc...which should total approx 30,000 records.

I am sure there is a way of matching the data..perhaps in Excell or Access.