how to merge ranges from multiple worksheets

C

crowleydl

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

Any suggestions for consolidating this data? I have tried without luc
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,
Daw
 
Top