How to reference tab names in formulas for tables.

[DAS85]

So we write a lot of excel sheets for pulling together monthly summaries of individual days, and i was wondering if there was someway to just reference the names of the tabs in a table, say if its just simple names like 1-31

Like, instead of using '1'! for that tab name, use B5!, so i don't have to go in and change the tab name for each individual line.

Thank You

[#2 · Accepted solution]

You have to use the function INDIRECT(B5 & "!$G:$G") but INDIRECT is a 'volatile' function meaning it will have to get re-calculated all the time and may have performance hits on excel

[#3]

That did it, you were just missing a Quotation mark after G, but thank you very much. This was absolutely killing me.

[#4]

you're welcome and good catch and fixed