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?