[Power Query] Refresh the loaded sheet based on the condition

I have a working file in which Power Query was utilized to cleanup data. The issue faced is that I grab data from multiple sources (since the format isn’t the same) which I want them to be loaded in 1 sheet.

1 source file can be an image file that has tabulated info, another source has the same format but more data, or a table embedded within an email (which I can copy into excel or save it as a .msg file).

My idea to tackle this, is to format all of them efficaciously and load the source based on the date present (if possible) so that the refresh button would run on date if-condition. If Source 1 has date June 1st, then it will load that sheet. If source 2 has June 2nd, then it will load that sheet. Piling the month data based on multiple sources.

However, if another possible/better way exists that would be great.

Thanks in advance!