Hey Guys and Gals

I having just finished my latest Excel project and am just trying to make it a little more user friendly.

I have two worksheets one called Names and one called SYA. A1 to A30 in Names are a list of names

Is it possible to have some sort of function that will copy worksheet SYA for every name that appears in A1 to A30?

Cheers

James