Itemize every field in every tab in every file within a folder

[Carluccio555]

I'm trying to do some prep work on aligning the field names across a folder full of many files, these files refer to fields that contain the same data but with different field names eg. Number, No, Doc No, Ref No, Ref etc.

I'd like to get an easily viewable list of every field, on every tab in every file within a folder to collect all the field names to start the basis for a field rename and then consolidation exercise.

Assuming that the field names are always on row 1 of every tab in every file, how can I get an output like the following:

Thanks in advance.

[binuacs · Accepted solution]

@Carluccio555 One way of doing this

[Carluccio555]

Thanks but I cant get this to run, it might be because my Alteryx version is Version: 2022.1.1.40869 Patch: 2.

I'm attempting to build it myself, the first batch macro is working but because the 'template' file is based on an xlsx it fails because some of the files are xlsm. Any ideas?

thanks