Excel data capture and graphics

I am a Fractional CFO; one of my clients has 70 + housing subdivisions that I support from a budget/actual/forecast perspective. The 1099 doing this work for me took a full-time job with one of my other clients and I am looking to replace him. The 70 + subdivisions each have an Excel Worksheet (since the file is so big, there are 3 Workbooks). Each sheet has historical P&L data, driver assumptions, and a forecast. The monthly data goes back up to 3 years and forward up 7 years. The data is summarized into calendar years and graphed. The graph comprises three sets of data: Income, Expenses, and Unit Sales. My immediate need is someone who knows about graphs across many worksheets, (I'm getting a "ref" for the horizontal access and should be getting calendar years). My longer-term need is for someone to take over managing the workbooks, importing new data (or doing data entry where import isn't practical) when it is available each month, and generally helping me with reporting and some light analysis.

Note on the attached file, I pulled one sheet out of the workbook; there was not a circular reference prior to me doing this and was one after. (I need help with this sort of thing too - I'm looking for a real Excel/Data Ninja, which I am not).