Making row1 as Header for all the queries

[learningpython]

Hi Experts,

I have 45 queries data loaded into power query, I need to promote row 1 as header and change column name to “Data” for all the 45queries
Instead of doing each query individually,
Can I have M language script to do the above at one go?
My data sources: It is an excel, with 45 tabs, I have loaded into excel power query.
Your help is appreciated

Regards