Dynamically append new tabs from Excel Workbook source upon PBI refresh

I hope the subject line explains it... i'm finding it hard to put into words what I am trying to do.

Basically, I have one excel workbook, lets call it "DataByWE.xls".  That workbook has a tab for every "Week", and the same structure of data is within each tab.

So, next week, when I go to update my data, I would create a new tab, name it accordingly, and "refresh".

Currently, I have to first add that new tab into PBI, manually, and then add it to the list of "appended" sources.

Is there a way to automate this... so when I 'refresh' it inspects the source xls file, sees that there's a new tab, and automatically adds it to the PBI?