[Doug McLean]

Completely agree with Vince.
Macros can do a lot, but can be tricky to write properly.
While Power Query can be a bit tricky to learn, once its done, its fully repeatable.