How to read multiple excel sheet

[muhammet.sezer2 (Muhammet Sezer)]

Hello, I have multiple Excel files.
All Excels have a sheet called “Dropdown List” and its contents are the same. However, I will not take any action regarding this page.
Some Excels have 2 sheets, while others only have the sheet named “Dropdown List”.
What I want to do is read all the Excel files and merge the sheet that is left out of the “Dropdown List”.
I will share photos of a few of them below.

Output:

[Yoichi]

HI,

Can you try the following sample? This creates a result file under result folder.

Sample
Sample20240614-1.zip (23.7 KB)

Regards,