Dynamic_Tab_Data

[excelhelp18]

Hi,

I need some help around the following:

I have some KPI's data for 9 circles. Each circle KPI's are there in seperate tabs.(File attached)

I need to do analysis on KPI's at consolidated level. To do this, I need to copy individual KPI data from 9 tabs, paste it seperate sheet and do the analysis...

KPI's are about 25 and to do this for each KPI would be challenging..I need some kind of formulae or macro in the analysis sheet that would fetch data from different tabs for a selected KPI..

Circle names are similar to tabs name and hence could be used to pull the data..

Kindly help solving this..

Thanks a lot...

[ConneXionLost]

Paste this formula in cell 'Analysis'!B5 and autofill down & across:

Please Login or Register  to view this content.

Cheers,