Referring to a worksheet in a closed workbook.

I've done quite a bit of searching, and apologize in advance if there is some obvious answer to this question I just haven't been able to come up with yet.

I'm reading data, from specific cells off a closed workbook. When the sheet that needs said cell data is activated, it automatically opens the workbook and references the sheet nessecary. The issue I've come across, is I now need to access another workbook (Easy to open) with 12 sheets 1 for each month, and only read from the worksheet of the actual Month...

Kind of lost on how to possibly make this work. I basically need something like:

=location/[workbook.xls]worksheet!cell - where worksheet = B12

and B12 =month(today()) and is formatted to MMMM



I realize that doesn't work, looking for another way around it. Any advice is greatly appreciated.

I'm using WinXP and Excel 1997

Thanks in advance for your help,

Albert


PS: This question has been posted on another forum as well... Post found here: http://www.mrexcel.com/forum/showthread.php?t=388107