Merging files with different yet very similar structures

1

I have multiple excel files that I'd like to merge into one they are structured similarly but not identically...each one has formatting at the top (company logo, text in some cells etc.) but below this there is a table structure that is the same in each of the files...but it's in different spots within the files.

Is there an efficient way (faster than me opening 40 files and just copying and pasting the data) to merge this.

For example:
the data I need from File 1 starts in cell B17 - with columns of
UPC # PART # MODEL # DESCRIPTION "INNER CARTON QTY."

Then in another file it has the same column names, but it starts in B13, another file in B15, and so on. Basically, all the sheets have the same headers, but they start in different cells of the excel file.

Sorry I am not able to post the files themselves due to restrictions.

2

The "Trim table by condition" action removes unnecessary rows until the specified condition is met. It's designed exactly for cases like that.

3

I'll check that out - I assume I'd need to run that for each file right?

4

Yes, in a loop.