First off, I always vouch for all Excel work to be done via Excel VBA. It is much faster and simpler to code than PAD; but not everyone knows how to use it, so PAD only solution is below.
This won't be all the logic for your specific case, but you should be able to derive a solution.
"Get Files" -> use File Filter *.xlsx (or use a Title*.xlsx if they all start with the same title).
Loop with Loop Index starting at 0 and ending at the 4; increment by 1
In the Loop:
1)Launch Excel opening File[%LoopIndex%]
So, the first loop will be loopindex 0 which will open File[0]...File[0] is the first file from "Get Files"
2)"Get first free row on column" specifying the column you are going to copy
3)"Copy Cells from worksheet" from Column 1 to Column %FirstFreeRow%
4)If LoopIndex = 0, Launch Excel (your new excel sheet that combines the copied columns)
4.1) If LoopIndex > 0, Attach to Excel (your new excel sheet that combines the copied columns)
5) "Paste cells to worksheet" (desired paste column row 1)
6) Attach to Excel (go back to the first workbook)
7) Close Excel (Save or Don't Save, whatever your preference)
Loop
Attach Excel to your new workbook that now has all your copied columns
Close Excel (Save As path/filename)
Best of luck!
