list totals for various sheets

[Tony H]

I have several worksheets (could be 2, could be 20) and I want to list the
totals into one final sheet

 

[Pete_UK]

List your sheet names in one column (eg column A), then in B1 use this
formula:

=INDIRECT("'"&A1&"'!H13")

This assumes your total is in cell H13 on each sheet - adjust to suit,
then copy down.

Hope this helps.

Pete

 

[Tony H]

Many thanks. Works a treat.

Tony H

List your sheet names in one column (eg column A), then in B1 use this
formula:

=INDIRECT("'"&A1&"'!H13")

This assumes your total is in cell H13 on each sheet - adjust to suit,
then copy down.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Tony - thanks for feeding back.

Pete