"Wes" wrote...
Thanks!

"KL" wrote:
You could try this:

1) menu InsertNameDefine...
2) write SHEETARRAY in the name box, and
=MID(GET.WORKBOOK(1),FIND("]",GET.WORKBOOK(1))+1,256+NOW())
....
Notes:

1.This method is not recommended for XL97 or 2000 as according to
Harlan Grove the XLM functions used this way may shut down the Excel
with the loss of unsaved data ( http://tinyurl.com/49oqa )
....

Test it. Use of XLM functions in defined names will crash Excel 97 and 2000
(and probably also Excel 95). If the OP's really in a school environment,
then the odds are high (at least in the US) that there's more than one
version of each application in use.

That said, it's difficult to see why such functionality would be needed in
worksheets that aren't static in design, i.e., referring to worksheets by
index number doesn't make sense in spreadsheet apps in which users could
insert or delete arbitrary worksheets (and thus fubar worksheet references).
If workbooks would be static/unchanging in terms of worksheet number and
order, it'd be safer to enter a list of worksheets in a range in one of the
worksheets (or use a new worksheet just to hold such a list), name that
range SheetArray (tangent: always better to use mixed case for defined names
and UDFs to make it immediately obvious they differ from built-in
functions), and use it instead.