Quote Originally Posted by MrShorty View Post
Before pursuing this approach to the problem, I would suggest that you look carefully at the overall task and see if it would be better approached as a database + pivot table project. I am not an expert on databases and pivot tables, but I see a lot of questions like this on the forum where the overall project would be easier and more powerful if the data were all combined into a single database/sheet, then use pivot tables and other database summary functions to summarize or extract the desired data.
Potentially but I'm making the workbook for someone else, who wants each budget captured on a separate sheet for reporting purposes....and also I don't know much about databases!