Multiple Excel files, with multiple tabs

Hard to provide M code with an example to work on.  You've combined one tab from multiple workbooks, which auto generates a function.  You can modify that function to start from the worksheet level (instead of the workbook level).  You then modify your query to expand all the excel files, filter for all the Kind = Sheet and filter out any that contain "Summary", then invoke your worksheet function.

If that isn't enough help, you can provide two mock Excel sheets with multiple tabs, and I will send back some M code to demonstrate.

This video also demonstrates how to do this - https://www.youtube.com/watch?v=tYqFIVH-SmY

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat