Firstly, the reason you're having this problem is because of the interactions of the layouts of the info you require
but hey, we all start somewhere, or all inherit bad designs from various people
My honest advice in this scenario is to copy and paste your grid down and then manually edit the rows in the new formulae
so where you have a 1, change it to an 8 etc etc in all the cells
Hopefully, this will be the most efficient way if you're only copying it down a few times
if, though, you're having to do this quite a few times (liek 20 or 30) I suspect you're in trouble....
with basic links like this, we can use =INDIRECT and tie it to the rounded up row number divided by 8
however, this would need to be incorperated into the fact that your switching from vertical to horizontal
further to that little twist is the fact that you're not just linking : you have IFs and CONCATENATIONS and SEARCHES in there also
which make a "global" solution based on blind info virtually impossible
Looking on the bright side though : one of the best lessons to learn is the need to look ahead in the initial design process so you don't paint yourself into a corner : a bit like snooker players, they look to see where their cue ball will end up *after* they've played their shot before they actually play the shot
if the manual method isn't viable for you, email me your spreadsheet and I'll take a look at it - although it may be to say "no, I'm not capable of solving this"
novulari@hotmail.com