hi,

I have a workbook containing a worksheet called Scorecard which is actually
a performance score (weightage) for agents for a particular month.

i have entered formulas & named ranges by which the formulas extract data
using VLOOKUP & named ranges from sheet2 & there is a 3rd sheet sheet3
called Key which gives the weightage for agents performance falling in
between a particular level.

like agent promises taken score is between 300 to 350, weightage will be 8
351 to
400, weightage will be 10
& so on & on.

the above is just to give an overview of what i have made.

There is a data validation listbox (using Data menu Validation, select
List, give a name range e.g. =months)
what i want to do is selecting the month from the data validation list e.g.
April, the "april" sheet should get activated & the defined ranges will get
updated for that sheet & automatically the formulas on scorecard will show
the correct data for April month. similarly, if May is selected from list,
May sheet will get activated & named ranges will update themselves with the
ranges in may sheet & eventually Scorecard sheet will reflect the data for
may.

Can anybody help me with this?

Eijaz