Output only Column names (Headers) from multiple excel files

[sowjanyayinti]

Multiple excel files with data.

Each excel file has a header row with anywhere between 4 to 44 column names.

Each excel file has 1000s of rows of data.

What is the easiest way to get a file that lists out the column names of all the files combined?

I am attaching sample files and the output I am looking for. 

I tried consolidating using multi join tool but drawing a blank on how to NOT report out the rows other than the column names.

TIA

[binuacs · Accepted solution]

@sowjanyayinti One way of doing this with the help of batch macro

[sowjanyayinti]

@binuacs - Thank you so much. That worked.