Excel VBA Multidimensional arrays

[JWM]

I am trying to determine how to reference an entire "row" or "column" of an array without looping through the entire thing in Excell VBA. In particular I hava a 3 dimensional array, with each dimension being roughly equivalent to the following:
1: Sheet number
2: Row Number
3: Column number

I would like to be able to copy all of the data from Sheet 1 of the array into a worksheet or another array. So far I have been unable to figure out if it is possible to refer to an entire row, column, sheet, etc. without looping. I imagine it looking something like:
newarray = oldarray(1,*,*)
or
newarray = oldarray(1, 1 to 5, 1 to 10)

Does anyone know if this is possible and how it might be done? Thanks.