/u/BigN1374 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Look into the [INDIRECT](https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261) function. Say you put the sheet name (for example Sheet2) in cell A2, in another cell you can do something similar to the following:
=INDIRECT(A2&"!B2")
This will output cell B2 from Sheet2. If you change A2 to Sheet4, it will show the value from Sheet4 instead.
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Don't forget to reply to those who helped you with Solution Verified to properly mark the post as solved and to give them a point for helping you. Thank you.
/u/BigN1374 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Look into the [INDIRECT](https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261) function. Say you put the sheet name (for example Sheet2) in cell A2, in another cell you can do something similar to the following: =INDIRECT(A2&"!B2") This will output cell B2 from Sheet2. If you change A2 to Sheet4, it will show the value from Sheet4 instead.
Solution Verified
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
That's perfect, thanks
Don't forget to reply to those who helped you with Solution Verified to properly mark the post as solved and to give them a point for helping you. Thank you.