rows($1:1) is the incrementer term, it returns 1, then 2, 3, etc when you
copy it down in any starting cell. rows($1:1)+1 simply adjusts it to start
the series at 2 instead of 1, as the example: INDIRECT("'"&J2&"'!HZ2")
starts at cell HZ2, not HZ1.

You'd probably need to fix the point to the sheetname in J2 as well when you
copy down: INDIRECT("'"&$J$2&"'!HZ"&rows($1:1)+1)
--
Max
Singapore
---
"ThunderBlade" wrote:
OK MAX,
Hope this reply is correct enough.
And if you would have read what I stated carefully, It didn't seem to work.
I did use your suggestion of doing the calcs on the host Worksheet, but I'm
still not getting the results I need.

I Understand the phrase that you gave before, but I'm not seeing the
&rows($1:1)+1) portion....can you explain it?