Multiple Data Tables Link and Calculate onto Target Tables

Hi,
I have attached a worksheet which I need some major help on. My problem is that I want to be able to populate an executive "Summary" worksheet for tracking energy usage by merely entering only the Month and Year. I want the worksheet to automatically extract data from the 3 tables in the lower section of the worksheet and fill into the appropriate cells in the upper section of the worksheet. These 3 tables for Electricity, Gas and MMBTU's, which are basically extracted from other files and worksheets will be normally hidden when printing the "Summary" sheet. For the purposes of this Thread, they are not linked elsewhere.

I've color coded the worksheet to hopefully make it easier to understand what I need. The red entry for June and 2010 should be the only manual entry made. The cell content displayed in green is what I want automatically entered. The cells with blue, purple and red borders in the 3 upper summary boxes are pulled from the corresponding blue, purple and red bordered cells in the 3 tables below. Ignore the dark greyed-out table.

The contents (simple formulas with relative cell entries) in the upper summary boxes are what I had to manually enter. Again, I need this to be automatically populated.

Is it even possible to do on Excel 2007? I don't know Visual Basic, so that's certainly not my first choice. I may be able to learn Macros quickly enough, but haven't tried it. I've already tried various Vlookup, sumif, etc., but no success. Your help would be most appreciated.

Thanks in advance