Get tables from multiple files

Hey guys

Assume I have three files:

week1.xlsx, containing data from row 1:10 and column A:F
week2.xlsx, also containing data from row 1:10 and column A:F

and

main.xlsx, the file I work with, which contains the worksheets T-1 and T

The directory is:

C:\work

Ok, now, when I load the week1.xlsx into the worksheet T-1 in main.xlsx, I do it like this:

=[week1.xslx]Sheet1!$A$1:$F$10

That works just fine. I do the same with the week2.xlsx into the worksheet T!

And then excel 2010 automatically adds a directroy header into the formula in both worksheets, like this:

='C:\work\[week1.xslx]Sheet1'!$A$1:$F$10
='C:\work\[week2.xslx]Sheet1'!$A$1:$F$10

Question 1: Why is that?

Question 2:

I can generate the String "'C:\work\[week1.xslx]Sheet1'!$A$1:$F$10" easily.

Problem is, that if I use it in the indirect function like this

=INDIRECT('C:\work\[week1.xslx]Sheet1'!$A$1:$F$10)

it does not work? Why?

Excel 2010 throws #REF! error

I'd appreciate some help a lot.
Thank you in advance

Oh,

I found it!
Excel's INDIRECT function does not support closed workbooks ... well, I am trying other workarounds. Thanks anyway