Try this:

=INDIRECT("'"&A1&"'!E19")+INDIRECT("'"&A1&"'!G19")

in B1 and then copy down.

An alternative is to amend the macro and do it in there.

Hope this helps.

Pete

On Jul 25, 11:19*am, Ernst - EXE Graphics
wrote:
Thanks Mike. That does the trick. Another question:

Now I have a list of names and I want to use the list with a formula to
calculate values from the sheet in the list:

sheet1 * * * *=+'sheet1'!E19+'sheet1'!G19
sheet2 * * * *=+'sheet2'!E19+'sheet2'!G19

How can I get the formula to get the sheet name from the list that was
created?



"Mike H" wrote:
Hi,

Right click the sheet tab of the 'other' sheet, View code and paste this in
and run it

Sub standard()
Dim x As Long
For x = 1 To Worksheets.Count
Cells(x, 1).Value = Sheets(x).Name
Next
End Sub

Mike

"Ernst - EXE Graphics" wrote:

I have a file with about 80 worksheets. How can I create a list in another
sheet that reflects all the sheet names- Hide quoted text -

- Show quoted text -