why doesn't INDEX work across multiple worksheets? If I
INDEX('247695:446068'!D5,1,1) where 247695 and 446068 are worksheet names,
"#VALUE" is returned. Any insight into how to get this work? Thanks.

-brian