Get Excels Files From a Folder Without Combining it

Hi, Abdelrhman_2020 

Based on your description, I'd like to suggest your create a function in Power Query as below.

(Path as text,ExcelName as text,SheetName as text)=> 
let
    Source = Folder.Files(Path),
    PathStep = Source{[#"Folder Path"=Path,Name=ExcelName]}[Content],
    #"Imported Excel" = Excel.Workbook(PathStep),
    SheetStep = #"Imported Excel"{[Item=SheetName,Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(SheetStep, [PromoteAllScalars=true])
in
   #"Promoted Headers"

You may input a set of parameters and get a a corresponding query. After executing multiple times, you can get tables what you want.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.