Vlookup Based on Cell Date

I have a range of data that pulls, via a vlookup, from another spreadsheet. The problem is the data is divided by month into individual spreadsheets.

I want the data on the spreadsheet I am working on to change based on what month is selected from a drop-down menu.

-Kurt

Try something like:

=INDIRECT(A10&"!A1")

Where cell A10 contains the selected value from the combobox, and A1 is the cell from which you want to get the value.


Mangesh