summing data in another worksheet using references

[Anthony]

Hi all,

I am having trouble summing data I have in work sheet2 into worksheet
1

I ahve the following formula

=MAX(INDIRECT(ADDRESS((MATCH(VALUE("31/12/2008"),'NVaR Exposure'!
E:E,-1)),6,4,TRUE) & ":" & ADDRESS((MATCH(VALUE("01/11/2008"),'NVaR
Exposure'!E:E,-1)),6,4,TRUE)))

where worksheet2 name = 'NVaR Exposure'

address(match(value("31/12/2008"),'NvaR Exposure'! E:E,-1)),6,4,true)
returns me F14
while the other address function returns F16...

When I sum the two, it sums up the value from F14:F16 on the current
worksheet
I tried

=MAX('NVaR Exposure'!INDIRECT(ADDRESS((MATCH(VALUE("31/12/2008"),'NVaR
Exposure'!E:E,-1)),6,4,TRUE) & ":" & ADDRESS((MATCH(VALUE
("01/11/2008"),'NVaR Exposure'!E:E,-1)),6,4,TRUE)))

but this is not a valid formula according to excel

Thanks in advance for all your help

Anthony