Ooof! That reordering and renaming must have hurt.
One of my first jobs when I got into data was combining several such sheets to produce a dataset that we then use downstream. Unfortunately one of those sheets was produced at least partially by hand, I think, because that's the only explanation for why column headers occasionally unpredictably had merged cells some weeks and didn't have them in other weeks. That taught me a lot about error checking. It was also very painful.