I'm not an expert but I can get my way through basic VBA coding. I started off simply by recording the macro for any repetitive actions I wanted done, reviewing the recorded macro, and tweaking appropriately. From there, any ideas that you can think of that will make your spreadsheet better I'd just google and get basic concepts, tweak, etc.
Just like @LPhan said above, i am not an expert at all but i simply learned from recording and reviewing. And to be honest with a lot of help from people on this forum. I barely started learning VBA about a year ago and to be honest it is a lot of fun when you get code to work perfectly the way you want it. And trust me when i say this.... Mistakes will make you a lot better! While im here at work i tend to come on this site and i go straight to the forum and try to help people out and that helps me learn. I also look at other's solutions and learn from those as well. And definitely google lol. Since i am studying software development right now i am trying to find resources and trust me, this is probably one of the best forums/resources that i have found.
You may also want to consider your own learning style. I generally come up with a task I want to accomplish, then dig in and use trial and error, and reading manuals, and googling concepts until I get it done. Then I move on to another project. Things generally stick better if you actually use it. Others are more visually oriented and use videos on YouTube.
MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts. MrExcel's Products: Books, CDs, Podcasts
Merging Data from Multiple Workbooks into a Summary Workbook in Excel
Merge data from all workbooks in a folder
Merging a Range from Selected Workbooks
Merging a Range from Multiple Workbooks by Column
Merging a Range from Multiple Workbooks in a Folder with a Filter