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?
A6=AFB
I want B6 = 'AFB'!A5
Do you think this calls for VBA?