Referencing worksheet tabs

[rbygo]

I have thirteen worksheet tabs in one file - one tab for each month, plus one worksheet tab that analyzes data from the current month. The worksheet tabs are lableld as follows:

JAN
FEB
MAR ...(etc, through DEC)
ANALYSIS

ANALYSIS cell A1 contains the name of the current month (in the same format as the monthly worksheet tab names.)
In ANALYSIS, I want cell B8 to pull in the contents of cell J4 from the current month worksheet tab, based on the month that is in ANALYSIS cell A1.

How do I structure the formula for ANALYSIS cell B8?

 

[DaleWatson123321]

Hi rbygo,

Here's the formula...

@@(A1&":J4&quot

I tested this to confirm it works, so you shouldn't have any problem, but please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[rbygo]

Perfect! I spent hours trying to find a solution. I should have come here first. This is much more elegant than the klunky method I was afraid I would have to use. Thanks, Dale!

 

[DaleWatson123321]

You're QUITE welcome. Thanks for the feedback.

Regards, ...Dale

 

[german12]

Was not here for a long time - great Dale!

Regards from Germany - Klaus