get data from multiple Excel sheets in one file hosted in Sharepoint

Hi Everyone

I hope you can help me here

so I have an excel file multilple worksheets( Matt, Anna, Carsten ,Dimitry etc etc )  and  all same data format   (person,date,booking Type,Product,Customer,Status etc ,etc )

I can grab all this in a simple single query in Powerbi, using "from Excel" however as its a local file  i cannot have automated refresh. 

let
Source = Excel.Workbook(File.Contents("C:\Users\Matt\Documents\Meetinginfo.xlsx"), null, true),
#"Filtered Rows" = Table.SelectRows(Source, each [Name] = "Matt" or [Name] = "Anna" or [Name] = "Carsten" or [Name] = "Dimitry" ),
#"Expanded Data" = Table.ExpandTableColumn(#"Filtered Rows", "Data", {"Column1", "Column10", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9"}, {"Column1", "Column10", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9"}),
#"Promoted Headers" = Table.PromoteHeaders(#"Expanded Data", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Agent", type text}, {"Date", type any}, {"booking type", type text}, {"customer", type text}, {"Partner", type text}, {"Requestor", type text}, {"status", type text}, {"comments", type text}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type", each ([Agent] <> null and [Agent] <> "Agent") and ([Date] <> null)),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows1",{"Anna", "Agent", "Language", "Date", "booking type", "Product", "customer", "Partner", "Requestor", "status", "comments"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Date", type date}}),
in
#"Removed Columns"

So i save it in Sharepoint, but how do i now make the query filter by "the file" - I have to do this first right ? 

AND then the sheets 
I hope this makes sence. In essence i want a multi sheet excel file report that I can aut refresh ...