Answering RichR's question I've made this example.

You choose the person and all data about it from every sheet appears below.

The formula I used is:

=INDIRECT(ADDRESS(The_One+1,COLUMN(),,,$A5))