Append several Sharepoint files with different header names

Hi,   I have 3 files that live on Sharepoint. Each week another one is added. They have a few columns in common, but also all have one or more different header names, that don't exist in the other ...