Data combination into csv file

We are combining our office data into a new operating system. We have all data in excel formats with a persons name as the one concistant or property address, we need to combine as much of this individual data under one name into a CSV or one combined excel file so we can import into our new operating system. Some of this data has script'ing' (?) we would need removed so the data is combined. Our information is in different formats and needs to be combined and read in the new system. we can send a send test data to see if possible, we are looking to get done asap please, we would like a test amount of say 5-10 names to see if our system will take the information. During the bidding process we can send test data if required or if we can via this site. Please let us know if we have communicated this effectively to you so you cab understand our needs.