Try Ron's:
http://www.rondebruin.nl/copy2.htm

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Banker" wrote:
Thanks for the response. Maybe this will help:
I want the data in cells B8:G59 on each of 7 worksheets to ALSO show on
Worksheet #8 with the data moved as follow:
Sheet 1 data from B8:G59 will show on Worksheet #8 on B8:G59
Sheet 2 data from B8:G59 will show on Worksheet #8 on B60:G111
Sheet 3 data from B8:G59 will show on Worksheet #8 on B112:G163
and so on until all of data from the 7 worksheet is ALSO listed on Worksheet
#8

I hope this is clearer.