How can we map the excel file columns.

Question

I have three excel files with different columns file1(a,b) file2(b,c), file3(c,d). how can we map the columns. like file4(a,b,c,d) to one file or list.