PQ - Import multiple tables by keyword match

[brawnystaff]

I am using Power Query to import an html file that I have on my local hard drive (from Web). Upon loading the file, I am confronted with the PQ Navigator window that allows me to "select multiple items" and select the multiple tables I wish to import. However, rather than do this each time, is there a way to automatically import all tables that I wish to import based on a keyword match? The keyword would be "Received Reassignments" with no quotes.

Sample code for one of the tables is below:

let
    Source = Web.Page(File.Contents("C:\Users\Me\Downloads\XCY\Data Report.html")),
    Data132 = Source{132}[Data]
in
    Data132

Thanks.

 

[brawnystaff]

Was able to solve on own. Basically, got rid of the second line in let statement (Data32= Source{132}{Data} and changed in statement to Source.

PQ Editor displayed on tables, and filtered from there..