Help with Excel +Sheet1!XY function please

Hello,

I'm using Excel to monitor some data from my class, but I'm a fairly novice user.

I've been using +Sheet1!XY to copy data from one sheet to another. I found it on this site and it's been a life saver and I just followed the instructions and it worked, but now I need to use it again but I'm stuck, can anyone help?

I have Sheet1 with names in column B from row 8 down, and then information going from column C to AZ. I need each named person to have their own sheet as well. So I used +Sheet1!C8 etc and mapped that all out on Sheet2. But on the next sheet I need to to copy the data from row 9, and so on. How do I easily do this change in the +Sheet1!XY formula without having to manually edit the row number in each cell on each sheet?

I wondered whether using Find and Replace for the row number might work?

Thanks for any help anyone can offer!