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.
Good luck