Combining data from multiple worksheets on import

[MS_Teck8932]

Only one of multiple sheets appear during the "Import from folders" option from the data tab.

[#2]

@MS_Teck8932 

Do you mean From Folder connector in Power Query? Yes, here you select only one, apply some transformation to it and all the rest will be transformed the same way, result is combined.