Insert rows and copy data from other sheets

Hey all -

I have a project that is currently beyond my skill level and will appreciate any assistance in pointing me in the right direction. I believe I am looking for a macro, but am not sure if there is a better solution.

Background - In the attached workbook there are 11 worksheets (1 Summary, 9 Areas, and 1 Input). Each month, I will be emailed the 9 Area worksheets and copy them into the file. Each Area worksheet has an account description in column A, variance in column F and place holders in columns I to T for an explanation and its associate $ amount.

My wishful thinking -Columns B through G on the Summary tab will automatically update. However, I would like to find a macro which will insert rows below the account descriptions in column A on the Summary tab and list the corresponding Area name, $ amount and explanations provided in the 9 Area worksheets on the Summary tab in columns H, I, J. (There is an example on the attached Summary tab cells H10 to J17 of what I am trying to explain).

I know it's a bit involved and will appreciate any assistance.

Popa