How to use tab name in a cell instead of typing tab name?

[smmvols84]

Often, we use something like =Current!A1 to retrieve data from tab name Current and print on Summary tab.   How can we use "Current" from Cell?  Thanks.

[#2 · Accepted solution]

@smmvols84 

On the Summary tab, you could use the following formula as an example:

=INDEX(INDIRECT("'" & A1 & "'!A1"), 1, 1)

=INDIRECT("'" & A1 & "'!A1")

Both the INDIRECT and INDEX/MATCH approaches achieve the same result, allowing you to reference cells dynamically based on the tab name specified in another cell. Choose the one that you find more convenient or suitable for your specific use case.

[#3]

Thank you for help.  I appreciate it very much.  @NikolinoDE