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.
