Insert sheet linkage

[Learn-more]

In a workbook, I have 2 sheets "xyz" and "abc".
If in sheet "xyz" cell a1 I have this formula =abc!a3, then it will return
the content of sheet "abc" cell a3.
However, instead of putting down "abc" in the formula, I want to put down
"abc" in sheet "xyz" cell a2 and have the formula in cell a1 to refer to it,
buy doing so, later on I can put different sheet name on it and get the
required data from other sheets.

I tried a few things buy didn't work, hope someone can give me a solution.

Thank you

 

[Pete_UK]

Change your formula to this:

=INDIRECT("'"&A2&"'!A3")

with your sheet name in A2. Note the apostrophes -
<quotes><apostrophe><quotes> and <quotes><apostrophe><exclamation
mark>.

Hope this helps.

Pete

 

[Learn-more]

It works, thank you very much.

My next job is to figure out how the function INDIRECT works.

Thanks.

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete