Referencing Sheet Name in Formula

[bsteeves]

In column A I have a list of about 350 tickers. Each ticker symbol has its own sheet. Is there a way to pull data from each respective sheet without manually typing out the formulas. For example:

A6=AFB

I want B6 = 'AFB'!A5

Do you think this calls for VBA?

 

[mgirvin]

Dear bsteeves,

If all the values in the various sheets were in A5,

You could use this formula:

=INDIRECT("'"&A6&"'!A5")

When you type this in, it would go like this: equal sign, the word INDIRECT, open parenthesis, double quote, single quote, double quote, ampersand, A6, ampersand, double quote, single quote, explanation point, A5, double quote, close parenthesis.

 

[bsteeves]

Thank you very much that is exactly what I need.