Look at the online help for INDIRECT, it might suit your needs.
Examples:

=INDIRECT("E"&H1)
=INDIRECT(ADDRESS(H1,5))

If H1 contains the number 1 then both formulas will locate the cell
E1.

HTH
Kostis Vezerides

On Jul 4, 6:56 pm, Shazzer wrote:
This is a bit hard to explain but I have a selection of ranges which I need
to be able to choose from and paste into another workbook.
For example, option 1 could have formulas or values in rows 1 to 4
options 2 might have a different formulas or values in 6 rows.
I want to be able to click in any cell in the new workbook and choose which
option I want and have those values copied over.
Sorry it's not very clear but I'm not sure how else to explain it. Any
advice from anyone who understands me???!!!