Assume the defined ranges a

Name1 =Data!$A$2:$A$6
Name2 =Data!$B$2:$B$6
etc

In Main,

A1 contains the DV to select: Name1, Name2, etc

One array option:

Select A2:A6, put in the formula bar and array-enter
(i.e. press CTRL+SHIFT+ENTER):
=IF(A1="","",INDIRECT(A1))

One non array option:

Put in A2:
=IF(A1="","",INDEX(INDIRECT($A$1),ROW(A1)))
Copy A2 down to A6

In both cases, A2:A6 will return the required data
for the defined range selected in A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JohnOC" wrote in message
...
Hi there,

I have about 15 ranges of data listed in columns on a worksheet titled
'Data', each list of data has a 'name'.

I need to pull that data automatically into another worksheet (in the same
workbook) titled 'main' by selecting the data 'name' using a drop-down
list
at the top of the 'main' worksheet. I am using excel Version 2003.

Many thanks for any assistance.