Insert Additional Language into Formula

[tom4lax]

I have a formula already in place, but I want to add language to the end of it, hoping to bypass the pitfalls of Indirect Functions. For example:

Please Login or Register  to view this content.

I want to replace the indirect with the actual name of the worksheet in cell A13. Is this possible? This would be inserted to the end of a formula.

[FDibbins]

meaning what? If you are referencing the contents of a cell for use within a formula, then you must use indirect() for that

Can you explain/show what you are trying to do?

[tom4lax]

Sure. Say for example the final formula I would like is this:

Please Login or Register  to view this content.

The way I have it now, the second part of the formula is using an indirect as I referenced above. Is there any way to instead look at Column A, then place the name of that worksheet into the formula above?

Let me know if this doesnt make sense and I'll put together an example.

thanks

[tom4lax]

I've attached example of what I'm looking to do. Indirect doesn't work well because you can't follow the formulas when auditing the spreadsheet.