Combining columns based on position and not headers

Is there a way to run a loop to consolidate 100+ Excel files into one table where the headers are different, but the data in the column positions is the same?

For example, “Number” as a header may change to “Num” but would still want to combine those as the output since it’s the second column.