I am fairly ok with macros. The way I learnt was by searching for exactly what you wanna achieve. For eg. search for “vba copy and paste cells”, “vba add new sheet”
One statement at a time and you’ll be good at vba in no time. If your learning style is course then you can have a look at the YT channel WiseOwlTutorials; he has a good tutorial on VBA.
You can learn fast and easy by watching youtube videos. Or better take a Udemy course when it’s on sale. Learning to code from books is a very old method and doesn’t work with modern everchanging coding landscape.
Buy any book on Visual Basic. It is same to the VBA available on MS Suite. Just objects are different. But language syntax varies. VB does not have the Excel object model directly exposed.