Power Query - list sheet names of original data

Hi there,

I have 3 sheets of data from 3 different tables, where I have used Power Query to consolidate into a single table (under Summary Tab).
However, I'd like to a column in the Power Query table, that lists the sheet name for each item that can be found from the original source (see expected results).

Expected.png

I have also attached the Excel file here for your information.

Thank you for your help.

Ken

Hi Marvin,

Thank you for this.
However, when I try to add a new sheet and create a new table. The PowerQuery cannot identify the new data is from this new sheet.
Presumably, this is because the following code does not cover any new sheet being added?

Please Login or Register  to view this content.

I have attached my problem here.

Would you be able to find a solution for this, so I can add new sheet, and all new data and sheet information can be transferred to the PQ summary table?

Thanks!