So long as your data is consistent or between columns on each spreadsheet, this should be relatively easy.
I'm only going to do a small "proof of concept" so there's not telling what kind of curve ball 1,400 files can have.
Basically, we want to get a list of all the files (with their fill paths), iterate through each one, copy the data, and paste to a new "appended" worksheet. If not already, make sure all the files are in the same directory to make this easier.
This initial setup is pretty simple. "Get Files in folder" to get a list of all the file paths.
"Launch Excel" with blank document to append all the data to.
A "For Each" loop iterating over the variable "Files" we created in the first step. This will give us the individiaul file paths for iteration.
Inside the loop, our first step is to get the first free row of the new document we are creating. This is to make sure we don't overwrite any data.
Next a second launch excel now opening the current existing file we want the data from.
We then want to read the data inside. This action has an additional option we can select if your files have headers. If so, check off the "First line...." slider under "Advanced"
Next we write the data to our new appended file. We start on the A column and for row, grab our variable from the "Get first free row" action.
Last, we close the current existing excel file.
After the loop, add a second close excel with the option to save the document with a path and name.
Here is the data in the spreadsheets:
And the final result:
Full Flow:
