Hi,
could you not use a Pivottable in the summary sheet, selecting Multiple
Consolidation ranges?

Worth a look....


Hth,
Oli

--
Message posted via http://www.officekb.com