Conflicted on use of VBA

I work in tax and am creating a new tax pack at my new job - I had been considering using VBA initially but due to all the people recommending avoiding it I decided not to and that turned out quite well since I learnt a lot about Power Query and its does a great job for most of what I want it to do!

That said, there are some aspects that I wanted to build into the tack pack that I could only use VBA for - mainly automatically generating certain tables with unique values from source data model tables and refreshing the target tables without impacting the data I've already placed in existing rows. Basically I have tried to really limit my use of VBA to nothing more than simple repetitive tasks which:

1. I can easily build a check in to confirm work well; and

2. In the event the code does not work I am easily able to replicate - although of course at a slower pace

I say all this to say I feel like there is a great benefit in learning basic VBA even at this point in time, I can see the sense in not delving too deep into it and writing a really long complex macro that will be a nightmare to maintain but I think writing a couple of shorts macros to do certain easy tasks and limit/eliminate the element of human error can really have a big ROI!