Using text from a cell as a filename

[Jumbala]

Hi everyone!

I'm trying to write some formulas in Excel to help me compile some statistics contained in cells from various .xml files, but I can't figure this out:

1. Let's say I want to get the data from cell J16 in the worksheet "table 1" in the file "week 29.xml" (same folder), I'd use ='[week 29.xml]Table 1'!$J$16

How do I make it so I can use the file name and worksheet name from some other cell's content?

Like, let's say I have the text "week 29.xml" in A1, and the text Table 1 in A2,how do I make it so it retrieves it from those cells?

How this would work in my head is I'd have to type something like: ='[A1]&A2'!$J$16 (where A1 = week 29.xml and A2 = Table 1), but seeing as this isn't how it works, I'm all out of ideas and Google hasn't helped me very much with it...

Thanks a lot in advance!

[Jumbala]

Seems like I found my problem... All I had to do is use the INDIRECT() function to make it work, I had tried it before but I was probably using it wrong, thanks anyway guys!