Load multiple sheets from multiple excel files

Hi leonghio,

To achieve your requirement, please refer to steps below:

1.Put all your workbooks in a folder, then click Get Data->Folder-> Edit.

2.After step 1, click context column then click Combine Files like below:

3.Choose which type of sheet you want to combine to a single table, here I choose Sheet 1, it means sheet1 in all the workbooks will be combined to a single table:

4.The result is like below:

Reference:

https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

Regards,

Jimmy Tao