Referencing cells from different files (INDIRECT)

Referencing cells from different files (INDIRECT)

Hey,
Is there a possibility to reference cells from different files? Let's assume that I have files file1 and file2. On file1 there are cell A1 with number 1 on it. And the same goes for file2 except that the cell A1 contains 2.

Your function reference says something about indirect referencing of other files with INDIRECT-function. However when I try to use for example a function "=INDIRECT("file2.Sheet1"&A1)" on some cell in file1 I got the error message #invalid formula!. The intuitive way of "=file2.Sheet1.A1 doesn't work either. It doesn't work even when "." are replaced with "!".

Is there a way to use multiple files and then gather information from those files to a separate file? This would be important also because the simultaneous editing of shared sheets is not allowed. It could be also used as a workaround for somebody locking a shared sheet when editing it.

Thanks or otherwise pretty good spreadsheet program!