Picking up a particular list

I have nine columns of numbers (A through J) with numbered headers on Row 1 of 0 through 9 on worksheet 1. (I've also tried by using "name ranging" the headers (i.e.: ZERO, ONE, TWO, etc).

Each column has a list of numbers up to 50 numbers starting on row 2 down to row 51 (i.e.: A2:A51, etc).

On worksheet 2 I've used the following coding using numbers in the coding:

A1 is where I put a number (let's say 2).

I'm wanting the entire associated list of numbers from Worksheet 1 Column C to appear starting A2 down to A51.

=IF($A$1>0,OFFSET(CHOOSE('FINAL SORT'!$A$1,0,1,2,3,4,5,6,7,8,9),ROW()-2,0))

Also tried by name ranging the Row 1 header:

=IF($A$1>0,OFFSET(CHOOSE('FINAL SORT'!$A$1,ZERO,ONE,TWO,THREE,FOUR,FIVE,SIX,SEVEN,EIGHT,NINE),ROW()-2,0))

I've also tried as an array and just as a straight copy down.

And all I get is a #VALUE!

What have I missed in the coding?