How do I make power query look at a new table every time a new sheet Is added

[SPS41]

Hi, I am new to power query and I have a hopefully easy question.

I have a template which has a table and I have made power query look at it and make changes, thus creating a new sheet with those changes.

Now if I want to add a new sheet which has a table in it just like the template but with a different sheet name, is there a way to make power query also look at the new sheet. Is there some vba code I can use or is there a way to make power query automatically do this?
Any help would be appreciated and thanks in advance!

 

[JEC]

You should be able to expand after using this

let
    Source = Excel.CurrentWorkbook(),
    last = Table.LastN(Source, 1)
in
    last

 

[SPS41]

You should be able to expand after using this

let
    Source = Excel.CurrentWorkbook(),
    last = Table.LastN(Source, 1)
in
    last

You should be able to expand after using this

I will try this out but I also found out that List.LastN is another way of tackling it. I don’t know how both work but I will try both and keep you updated.

 

[SPS41]

Tweaked it a little and it worked for me. Appreciate it and thanks for all the help!