How to group multiple excel files into one table

I have twenty excel files each contain 1 row 2 columns, I wish to group them in one table (in total 20 rows 2 columns). I have seen some codes with for loops and dir, but they are not working out.

Answer 1

[Star Strider]

Since ‘not working out’ is not descriptive, see if the documentation section on Import or Export a Sequence of Files can help.

[Hussein Al Jebaei]

Thank you for the reference.

[Star Strider]

As always, my pleasure!

I hope it works in your application of it!