How to index all the values from an array

[billyshears]

Lets say in Worksheet 1, Colum A, I have the following:

Blue
Red
Green
Orange
Purple
Violet

and I called that Range "Colors"

On worksheet 2, what formula do I use if I want to create a list of all the values from "Colors" and have them appear in worksheet 2 when I drag it down.

I dont want to simply write that worksheet2A1 = worksheet1A1

I want a formula I can always use somewhere that will return all the values from Colors

[dosydos]

you could do something like:
=INDEX(colors,ROW(1:1))

[billyshears]

you could do something like:
=INDEX(colors,ROW(1:1))

Great thank you that worked very well.

Last question, is there a way to alphabetize the list using this same method?

[dosydos]

if you have excel 365 then you can use the SORT() function.
Otherwise you probably need to go to your source data and alphabetize it there by making the data a table perhaps.