To be more clear, in a sheet (Sheet1 for example) of a workbook, I setup
reading data (lets say "data1" and put it in "A1") from a file (so many files
in fact). I read the number from a specific cell in the source file. Now in
this sheet (again sheet1) I go to column M for example and want to read some
other data from source file again which is in same column as "A1"but 6 rows
above the "data1" and put it in M14 for example. If I get first one right
then G14, H14 and I14 would be easy to o ahead.
I try your last suggestion.

"JLatham" wrote:

Since OFFSET failed so miserably (my apology for sending you down that dead
end), you may be just as easy off setting up the new formulas manually. You
could simply copy one that's set up properly and paste it where you need and
change the column and row number references.

But if your need for F17, G17, H17 and I17 are all on the same row, you
could enter the first formula as C:\me2\wa\sourcefile\[st_T_0.xls]!F$17
and copy across the row, the F would change to G, H and I automatically.
Same for the other workbooks.

I'll continue to think about it and maybe someone else will fall in here
with a better solution.
"Darius" wrote:

I have a data sheet value as:
C:\me2\wa\sourcefile\[st_T_0.xls]T30!$F$23
C:\me2\wa\sourcefile\[st_T_10.xls]T30!$F$33
C:\me2\wa\sourcefile\[st_T_20.xls]T30!$F$43

now I want to get data in same sheet (T30) from F17, G17,H17,I17 in other
words each time "F" cell number minues 6 makes the first required cell
address e.g. F23 - 6 = F17 and then G17 etc.

How do I do that in an easy way?