VBA to Get SUMMARY of Multipple Sheet

[mag]

Thanks Lalit That Great if i want add new column What changes i have to Do?? when i add new row i can still get result i need get result if i add new column also Please Let Me know..