VBA to Open Previous Month's Spreadsheet and Pull figures from table using Account, Month

Hello all,

I'll be needing to write a little code but before I started, I was wondering if there were any examples already out there that I can borrow and tweak - I'm not the best at coding, but I can get by... code modification suits me much better than creation but I can create from scratch if needed... I just wanted to know if someone else has done the legwork already...

Requirement:
- code that will open a previous month's workbook, activate a specific worksheet, based on the month [row 10], and based on the account [column b], will need to bring in the appropriate amount and paste it into the current months spreadsheet. (My immediate thoughts were to use index & match but that's formula based, not sure if there's a better way)
- then copy for the rest of the months and move onto the next account, and then onto the next worksheet. [I think I can do this last part without a problem]

Background:
- This is a forecasting spreadsheet and we're looking to bring in the previous months forecast into the current month's sheet for comparison... ie: go into feb forecast and see how much we thought we'd be spending in march, and for the training account, and for travel, etc...


Any code snippets or samples that anyone has would be greatly appreciated.
Thanks for your help!

I've attached an example - if you need more information please let me know.
Thanks a lot for your help.

bump no response