accessing values in cells

[march madness]

If I want to access the values in cells when the cells are in different worksheets, how do I do that? i.e., there are 10 worksheets, 10 cells and 10 values in those cells. I want to create an array of those values. How do I do it? Note: I will be creating a new array of the same cells' values often, and the values will be changing. Each time I create the array, the array with the new values will overwrite the old array, and it's old values, so I'd like to automate this as much as possible.

For the sake of the example, let's say the values are in cell A2 in each worksheet, and each worksheet has it's default name, i.e. "Sheet1."

Any suggestions?