Hi all,

I've got a workbook with approx 15 sheets, each of which contains the same information, in the same cells, but for different individuals.

I want to have a front control sheet, whereby you can select an individual's name from a drop down list, and the information for that individual appears within the template on the control sheet. I've created a range for each individual, but need some help to get the control template to reference the correct sheet.

Any sugestions gratefully received!

Steve