Power Query on PBI and Automatic updates on PBI desktop

I have 37 excel workbooks which need to be reformatted for use in PBI and then an automatic set up done to update future workbooks.

Deliverables
Just need the raw data on PBI and then the update set