Monthly Financial Statements

I’m trying to create a VBA macro in excel to combine monthly financial statements into one model. Any tips on how to approach this?