Extracting the same column from multiple sheets

[beternal]

No use posting an example sheet for this...

Say I have multiple sheets in a workbook, I.e. sheet 1, sheet 2, sheet 3

How would I extract column A from each sheet and put them in order into a new sheet, I.e. sheet 4?

Could it be done on multiple excel files?... I.e. if I have files sorted alphabetically or by date, could I extract the first column from each of them into a new file in that order (or at the very least with a row header equivalent to each of the filenames so they can be sorted later?...

[Pepe Le Mokko]

Try https://www.rondebruin.nl/win/section3.htm
or
https://www.rondebruin.nl/win/addins/rdbmerge.htm