How to use named range in a formula?

Hello Everyone and happy new year,

I came across "Name range/Define range" and as I understand it, it is a function(?) that can help simplify/shorten formulas.

In the attached file, I have setup three sheets called Jan, Feb & Mar. In the 4.th sheet called Total, I defined Jan, Feb & Mar as "Months".

As you can see on Sheet "Total" In Cell B3,

Jan Sheet.jpg..................Total Sheet.jpg

I managed to use Index together with Match formula, to receive the Total from Sheet "Jan" with the formula:

=INDEX(Jan!B:C,MATCH("Total",Jan!B:B,0),2)

Now I am wondering, if I can replace the reference to the location in the sheets by using the defined range, or is it even possible to use the named range to shorten a formula on such way?

It would be a "nice to have", to avoid copying the formula and to change every time the month. Maybe it is possible?

I tried in Cell C4 to modify the formula by replacing the cell-name with:

"'"&Months&"'!

and the formula then looks like this:

=INDEX("'"&Months&"'!B:C",MATCH("Total","'"&Months&"'!B:B",0),2)

Unfortunately, I end up with an error, so my question is, am I doing something wrong or is it even possible?

Thank you for any help

Thanx a lot Glenn,
That did the trick ! I will try to avoid the whole column reference as you explained but what, if the differ in lengths? Shall I just go up to 100 if I am somewhere between 60-80 or what would be a good approach?

I am sorry, trying to give you some reputation I get the following:

You must spread some Reputation around before giving it to AliGW again. ;( Not nice... any other way, I can do so?

I will do so. Thanx again to both of you... anything else I have to do on my side?

Perfect, will do so, thanx a lot.