Using cell value in formula to reference a sheet name

[pba1]

There seems to have been a lot of questions of this type but none seem to address specifically what I am seeking.
My workbook has many worksheets. They all have the same data but relate to a different source Each sheet is named using that source reference (a number)
I wish to summarize the data in a summary table. Each source on a separate row.
Example
Column A includes a number that I want to use to relate to the sheet with the same name
Column B for eg average(sheet name = column a) a1: a15)
I would like to be able to create the formula once and copy it down so that each row reflects the calculaton from the sheet name in column A
Any suggestions?
Thanks

 

[Aladin Akyurek]

There seems to have been a lot of questions of this type but none seem to address specifically what I am seeking.
My workbook has many worksheets. They all have the same data but relate to a different source Each sheet is named using that source reference (a number)
I wish to summarize the data in a summary table. Each source on a separate row.
Example
Column A includes a number that I want to use to relate to the sheet with the same name
Column B for eg average(sheet name = column a) a1: a15)
I would like to be able to create the formula once and copy it down so that each row reflects the calculaton from the sheet name in column A
Any suggestions?
Thanks

Looks like...

=AVERAGE(INDIRECT("'"&$A1&"'!E2:E100"))

This yield an average of E2:E100 from sheet specified in A1.

 

[pba1]

Thanks This saves a lot of time and avoids errors.
Much appreciated.
Peter

 

[Aladin Akyurek]

Thanks This saves a lot of time and avoids errors.
Much appreciated.
Peter

You are welcome. Thanks for providing feedback.