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 hour copy-pasting them into one sheet. Excel already has a built-in way to do this: Power Query. Here