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.