Excel 2007 : Consolidating different values under different Names inDifferent Tabs to Master Sheet

Hi,
I want to consolidate values against a particular Name in a master sheet.

- I have 48 Tabs in Excel sheet.
- Each Tab has some Names & some values..(Ex. A=7,B=4,F=65 etc)
- The existence of Names (A,B,C etc) are random in a particular tab.Ex. It is not necessary that 'A' is available every time in a tab.
- I want to consolidate all 48 Tabs into a master Summary tab (say 49) where i want to do a total of whatever names (A,B,C,D,E,F,,etc) exist in 48 tabs.
- Problem is there is no symmetry in any two tabs.
Please help me.I don't want to do it manually.

Hi Rajeev. See if this is what you're looking for.

Please Login or Register  to view this content.