Adding various workbooks to one main consolidated worksheet

[MAZUSM]

HI there,
As usual I appreciate your excellent help.
Following is tricky and I am sure the way I am doing at this moment is very tedious.
I have worksheets of different workbooks (same structured) and wants to prepare the consolidated sheet by adding one sheet of each workbook (same structure). That means it requires copying the data and adding it with other data and pasting it in the consolidated sheet as sum.
Hmm! Now the way I am doing is by linking each cell with the other workbooks and adding it with another link of the workbook. Very long method and has full chances of errors.

May I get a super performer who can help me here? But please keep this in mind that I am not very advanced user of Excel. Appreciate your help!

 

[VoG]

This may help you http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[MAZUSM]

Thanks VoG. Seems like this is a good solution.
Don't we have any simple solution? What do I have to do with this long list of codes?
My apologies as I am just a beginner beginner in macros.

 

[MAZUSM]

Anyhelp please!!!