Ok, so I am trying to populate a report based on various months.

I will have data pasted in the report for July 2009 through December 2009. Each week I will update the current month with month to date sales information, so the current month's data will be overwritten as I get more up to date sales data. One area will be for July (ex A:D) and will be overwritten until the month end numbers are pasted, then I will begin populating the next month's data, August (cells E:H). Each month will have the same categories and fields, but just contain the new month's sales information.

What I want to do, is on my main page, have this same information listed in a neat and format, and based on a drop down box, the data will be updated based on the month I choose (example: the drop down list will contain each month - July 2009 through December 2009 and when I choose August 2009 it will list August's sales data in the fields below and etc...).

I have named each month's data using named ranges. Example, A1:D20 is named July2009, etc. I need the drop down box to list these named ranges and I will have formulas in the cells of my report, which updates the data based on the month that is selected.

I do not know how to set up my drop down box to list named ranges however, instead of a simple list, and I do not know how to reference the named range from the list (example the drop down is in cell A2, so I choose 'July2009' from A2 - I now need to have a formula that is something like this: =vlookup(A4,"need my named range here-depending on which one is selected from drop down),2,false).

My main sheet will look like this:

................Area1.......Area2.........Area3
Product1
Product2
Product3
Product4


All areas will have sales for a certain month, and each area will have sales for multiple products. I need to populate this based on my data dumps (of multiple months) based on the some type of formula and list selection (for my month).

I need help, as I don't even know what to type to google information on this. I prefer NOT to use a pivot table as I need the data listed EXACTLY how it is pasted into the sheet and will be updating this data weekly.

Hope I was clear enough, and thanks in advance for any and all help offered.