formula-link to a page vertical to horizontal autofill

[jlr123]

I have horizontal table that I want to link to another page which is in vertical order. And to auto fill vertical to horizontal.

Example: ='Adam'!O5 -next cell on page would be 'Adam' !O6

Need to autofill across the Main Page:

Main Page ADE -Column headers are horizontal Group1, Group2, Group3 to correspond to vertical 'Adam'! 05, O6,O7

Thanks very much.