I want to use the result in a cell to complete the worksheet name part of a
formula, so that the worksheet name can be a variable.
eg. ='sheet2'!A4
but the sheet name needs to be able to change depending on what is in cell
C2 on sheet 1.
Is there already a function that will pull together the text 'Sheet the
value in cell C2 and the text '!A4 and use it as a formula?
or will I need to write a function in VB?

Look at INDIRECT() in XL Help:

For instance:

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

In article ,
Chris wrote:

I want to use the result in a cell to complete the worksheet name part of a
formula, so that the worksheet name can be a variable.
eg. ='sheet2'!A4
but the sheet name needs to be able to change depending on what is in cell
C2 on sheet 1.
Is there already a function that will pull together the text 'Sheet the
value in cell C2 and the text '!A4 and use it as a formula?
or will I need to write a function in VB?