How to add source reference to records

[ggirf14]

I have a workbook with +/- 200 worksheets. I'm starting to explore to use Power Query with Excel 2013.
I start with a blank query and use this for the source:
Excel.CurrentWorkbook()

Question: How could I append a new row that will contain the sheet name each record came from?

 

[sandy666]

maybe New Query - From File - From Workbook (itself)
then select the name the of workbook only and Edit
you'll get the table of the tables with the sheets names

 

[ggirf14]

No luck, I'm forced to select tables, I cannot select the workbook itself.

 

[sandy666]

From Workbook the select workbook which you are using right now
if your open workbook with 100 sheets has name MyWorkbook so select it

eg. your workbook with 100 sheets has name Book234.xlsm, so From File, select workbook Book234.xlsm then select the name only Book234.xlsm (x) and Edit
x = how many tables exist in this workbook

 

[ggirf14]

Thanks sandy666 you were right. I can select the container of all the tables. Than the editor loaded the data with the additional column.

 

[sandy666]

Well, so Happy Querying