Power Query - Transform all sheets into a common Format and then Append
I have multiple excel sheets with data sample as below:
I have created a common format in Power query as this:
When i am adding all sheets from a folder, i want all the sheets to be transformed into the header format and then append. If i am doing the transformations for current 2 sheets, how can i make sure that if i add other sheets into the folder in future that would transformed automatically into same format.