Import cells from closed excel files

Hi all,

I am trying to import a row of data from another closed excel file w/o Macros.
Let's suppose that in an opened excel (OpenedExcel.xls) file in cell A1 I have a text with the path of the closed excel file (ex: R:\Dati\ClosedExcel.xls)
Is there a way to copy one cell of the ClosedExcel in the OpenedExcel using the above mentioned path?
(I need to use a path because I need to copy multiple cells from multiple closed excel files).
I've seen that there is INDIRECT() function but seems that it doesn't work with closed files...

Thanks in advance

Thank you for your answer but let's suppose that I have to import data from multiple closed excel files and I don't want to write each time:
A1: R:\Dati\[ClosedExcel1.xls]SheetName!Location Cell
B1: R:\Dati\[ClosedExcel2.xls]SheetName!Location Cell
C1: R:\Dati\[ClosedExcel3.xls]SheetName!Location Cell
...

is there a way to specify only the name of the files (ClosedExcel1, ...) and then using concatenate to create the full path and then using the full path in a formula like the one you have suggested me?
Thanks