I am looking for the type of formula that will return the values in a range
of cells based upon the value in one cell.

If the value in cell A1 is "1" in worksheet "First" then return a range of
values from 25 cells A1:A25 in worksheet "Second" and if the value in A1 is
"2" in worksheet "First" then return a range of values from 25 cells B1:B25
in worksheet "Second" and so on.

I want to be able to change a range of cell values to the right of the
primary cell based upon the value in the primary cell. If the value in this
cell is "1" then go to another worksheet and find the range of cell values
that will be copied to the right of primary cell.

I hope this is clear.

Thanks