Hi,

Consolidate function is useful for budgetary consolidation purpose
However, if there are 12 worksheets to be consolidated, then
consolidate function is unable to call back and consolidate say 45
worksheets as it has reached the max limit of consolidation ( ie 12
sheets )
In this case, is there any options/alternatives available either on
excel function or excel vba to solve this problem ?


Thanks & Regards
Len