Ron de Bruin has sample code that you could adapt to your workbook:

http://www.rondebruin.nl/tips.htm

scottcts wrote:
I'm having trouble figuring out how to simply take data from multiple
worksheets and list it in one "total" worksheet all within the same workbook.
I want to have this perform automatically as opposed to me using the
copy/paste function and do this manually. All the data will be in the same
layout from page to page. Any help would be appreciated.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html