I have 32 multiple worksheets, and the same range of data on each of
these sheets - but there are a few other sheets that are different. I
would like to pull all the range information to another worksheet
(dynamically), where I can sort it anyway needed.

Any suggestions for consolidating this data? I have tried without luck
to find an answer already posted. I did find a way to copy the data -
http://www.rondebruin.nl/copy2.htm#range - but this is not dynamic.
Any help would be greatly appreciated.

Thanks,
Dawn


--
crowleydl
------------------------------------------------------------------------
crowleydl's Profile: http://www.excelforum.com/member.php...o&userid=25968
View this thread: http://www.excelforum.com/showthread...hreadid=393407