How to get specific rows from multiple excel files

Hello everyone

I have multiple excel files, with multiple excel sheets. What I intend to do is to go in every sheet of every excel file in a particular folder and only pick out the rows from those sheets that are between certain cells with certain contents.

For example:

excelfile1 has sheet1 where in row 17 there is a cell with content that says "List of shops" and then the subsequent rows have data about shops. Once the list of shops is finished the next cell reads "list ends here". each sheet in each excel can have any number of shops in the list. some might have 4, others might have 14. but i only need the row data from each sheet in each excel that is between those cells "list of shops" & "list ends here"

Also for each of the rows picked up i need a column that says while file-sheet name the data was picked from.

Kindly help. Thanks