Output only Column names (Headers) from multiple excel files

Question

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

File1.xlsx

File2.xlsx

File3.xlsx

Output I Want.xlsx

binu_acs · Accepted Answer

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