Extract all approx match determined from expandable list in sheet two and create table

I download a daily inventory file from my supplier.
.
I sell only selected products from that file.
.
I would like to use a list of the product part numbers of the products I sell on sheet 2 (Inventory) and have all the results from sheet 1 (ProductFeed) built into an expandable table on sheet two including all the parts numbers (expandable because I will add or delete part numbers from the list) I have listed and not just one part number but several.
.
Second issue: the download file contains part numbers in column "A" with variables like 418, 418_color, 418_size etc.... I would like all part numbers that begin with the number 418 and the ones that contain the variable added to be listed in the new table so I will get a list of all part number 418 and the variables which include 418 in them.
.
I want to return the results of the whole row(s) of the matched data as well in the new table.
.
I have attached a file of the working data that I have with the data I will use although the ProductFeed will change daily which I intend to copy and paste into the table each day.
.
I would appreciate any help as I have been studying this for several hours without solution.

The zip file I attached does not include the "Inventory" sheet because it is a csv file and it doesn't allow csv workbooks to have multiple pages
I have a file attached for the data/product numbers I want to extract

OK I will try this again since I haven't gotten any replies and I cannot for the life of me find any other solution in this forum. I have tried and tried many of the suggested formulas from other threads but not getting the results I need.
.
I hope this helps you understand what I need. It is a little bit different from the original question but still the same principle.
.
I need to extract all the items that I sell from the source dadatfeed I get from my supplier from sheet 1 and place the entire row into a blank row on sheet 2 and highlight (in red) all the cells in column E that say “no”

The included photo's below I hope will help give you the idea of what I am working with.

ANY help would be appreciated.

ExhibitA.jpg

ExhinitB.jpg

ExhibitC.jpg

I'm not sure how to make the pictures visible right in this post, I apologize

Thank You,
Barry