There is no silver bullet on this one... Check out this link.
http://www.rondebruin.nl/summary.htm

You could also use a pivot table with multiple consolidation ranges...

--
HTH...

Jim Thomlinson


"240" wrote:


I have about 8 worksheets all containing data from different customer
accounts. The column heading for all 8 worksheets are the same. I would
like to consolidate all eight sheets into one. How can I accomplish this
without using the copying and pasting feature?