I have got a report that i want users to be able to pick thier name on a summary sheet from a drop down list and the subsequent 5 sheets will be filtered on thier name.

Is this enough detail or do you need specific cell refs?

Thanks
Andy