Listing data from multiple worksheets

[Guest]

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.

 

[Guest]

Just type "=" in any cell, click over to the other worksheets and choose the
cell you want.

For example if you want to reference cell A1 in tab "Sheet2" Excel will
create the formula:

=Sheet2!A1

 

[Ron de Bruin]

Hi

Maybe you like this
http://www.rondebruin.nl/copy2.htm

Or
http://www.rondebruin.nl/summary.htm

 

[Debra Dalgleish]

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

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