Ok, so you pasted the formula, but what result did you get?

The ROWS part, when copied down, is designed to give successively ROWS($A$1:$A2) (=2), ROWS($A$1:$A3) (=3), ROWS($A$1:$A4) (=4), etc. which will append to the end of "Person" and therefore tell Excel to look in, successively, Person1, Person2, Person3, Person4, etc. Providing your tabs are named precisely that (with no spaces), I can't see what the problem could be.

Regards

Edit: just seen your post - so all is good, then? Can you mark this one as solved now?