Automate Power Query using Macro in Excel

Hi,

I am using Power query to sort my data after combining .txt files in the power query and perform processes like removing few column, pivoting data, removing blank rows that comes from CMM. Is there a way to use the defined M code in a Macro to perform all this steps automatically once I select the location of the file. As the file headers remain the same, these are just the dimensions of a part.

Please help me out.

Thank you.