Excel - Power Query How to combine multiple tables using a combination of Append and Merge

Use Case: I receive 7 data files (csv and Excel), from various suppliers, in various formats. I clean the data through Power Query into the same column headers. I now need to combine these files/tabl...