refer part of a multi dimension array

I have a 2 dimensional array: ar(1 to 2, 1 to 100). I need to refer to the first element of the first dimension ar(1, 1 to 100) without creating a new one. Is that possible? The reason I don't want to create a separate new array is because I need to use the value of the the second element of the first dimension ar(2, 1 to 100). For example something like:

for i=1 to 100
     ar(1, i)=worksheets(i).name
     ar(2, i)=worksheets(i).index
next

Then I want to do something like:

for x=1 to 100
   anotherAr(x)=application.worksheetfunction.large(ar(1,1 to 100),x )
next

But I don't think ar(1, 1 to 100) is recognized.

To give a better explanation, for example, I need to create an array of the worksheet name sorted with their corresponding indexes based on the array of randomized sheet name and their indexes. I know this may not be the best description of my problem and I know there are other ways to achieve this specific goal but I am wondering if an array can be used so I can use it for other purposes. Many thanks in advance!