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?