Hi there.

I need your help. Here is the situation: I have multiple xls files and each has multiple sheets and each sheetname in the different files are identical. Ok... i think i explained that wrong... File 1 has the sheets A, B, C, D, E and F. File two has also the Sheet names A, B, C, D, E and F, so does file 3 and file 4. In sheet 1 i centralize the data from files 2->4 but in sheet A from the Sheet A of the files 2->4, in sheet B the data from the sheets B of the files 2->4 and so on. Now, how can i make a formula in sheet A of file 1 so that it only shows me the data from sheet A of the files 2->4 BUT if i copy the same formula in sheet B it will automatically show me the cumulative datas of sheet B in the files 2->4?
Is this posible with Excel 2003?

Thank you in advance.