Getting part of a worksheet name from a cell value

[mainemojo]

Using a formula, is it possible to reference another cell on a different worksheet such as:

Please Login or Register  to view this content.

But instead of using the worksheet name, get the value from a cell on the same worksheet that the formula is on such as:

Please Login or Register  to view this content.

so that basically, if the value for $A103 is 'Sheet1', then it would be the same as the first formula?

[KOKOSEK]

Please Login or Register  to view this content.

[Squeaky]

Use the indirect formula. If your sheet name has a space in it make sure you put the single hash 'sheet 1' around the name.

[mainemojo]

KOKOSEK - the formula I eventually ended up finding was:

Please Login or Register  to view this content.

As you see, the quotes are different. Does it matter if it is how I put it, you put it, or Squeaky has it? If I have a lot of similar formulas, does the quote placement impact performance?