I'm having a problem with a Index/Match formula

Hi Guys, please can someone help, I'm having a problem with a Index/Match formula

I have 1 sheet with names that have been grouped and therefore have gaps inbetween like this:
A B
Gabbi 0.982053096
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
James #REF!
Rachel #REF!
Calvin #REF!
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Barry #REF!
Peter #REF!

Now i have another sheet with their names going accross and their numbers below:
A B C D E F
Gabbi James Rachel Calvin Barry Peter
0.95 1.00 0.95 0.93 0.99 0.95



All the above is not in order, the names are spread accross the sheet randomly,
I would like the first, linear list, to collect the numbers and below their names, as you can see i cant get it right??

any help would be appreciated
Thanks
Paul

apologies, hope this comes out better, I have 2 lists, 1 going downwards & the other going accross, in 2 different sheets.
I'm trying to get the number below the person in the horizontal row to show next to the name in the vertical row?

Gabbi 0.981495428
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
James #REF!
Rachel #REF!
Calvin #REF!
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Barry #REF!
Peter #REF!




Gabbi James Rachel Calvin Barry Peter
0.949105825 1.006011901 0.950870247 0.934199649 0.981495428 0.9955556