Need Macro that pulls Data from one sheet and pastes into other specific sheets

I have all data in one sheet and need to find specific data and paste that into specific sheets. Is there a macro that will help me do this?

For example:
On my 'Data' sheet I have Agent names (A1:A:500), Cells B1:K500 contains all customer information.

I want to take specific agent names and their customers and paste the customer information in rows of agent names tab. (Along the bottom I have different sheets for each agent name and their customers information inside)

So, I want to take Agent John Doe's customers information from my Data sheet and paste that information into John Doe's specific sheet.(This sheet could be created with a macro, or dumped into an existing agent named sheet.)

Thanks for any help or suggestions.

hi palmetto
thats macro script works but for along row a1.

so if i got data on a2, a3 and so on, what on that script i need change?

thanks for ur expertise on excel vba

abu

hi palmetto
i got it, i just need to change range for a1 to range of row i need to copy.
thanks for ur expertise on excel vba

abu

Can you expand on that Alimamak?

When I try to run this macro, my title page on all agent sheets just copies down as I change the A1 to various ranges.
There is no title on the Data page that I am trying to pull agent info from.