Merge many Excel/CSV files into one sheet: Power Query steps and 3 gotchas

Every month someone sends you twelve branch reports, or a folder of CSV exports, and you spend an...