Power Query M , multiple sheet combine, add sheet name as new column to each corresponding table

[k-k-k-k]

hi experts,

i have action is combine 10+ sheet table in one Excel， the sheet name is contain "year" info, like the sheet name is "2018". but in the table of sheet is not have year column.   so i need extract the sheet name to table's column.  i know there expand table will keep the sheet name for every sheet table, BUT ,  there's some special reason, i need add the column first  for every table before expand. 

I think there should  some M function or expression can do, but i have no idea. could yo help me ?   thank you very much!

[k-k-k-k]

Hi daniel,  the expression is works well, it solve my problem.  thank you very much!  u are so powerful .

[wdx223_Daniel · Accepted solution]

NewStep=#table(Table.ColumnNames(PreviousStepName),Table.ToList(PreviousStepName,each {_{0},Table.AddColumn(_{1},"Year",(x)=>_{0})}))