Contents of 2 excels into one based on column name

Brother, would you please elaborate more or any other way…I am not comfortable with LINQ queries.