How about a relatively easy, fast, normal formulas set-up
which automates the exact functionalities that you seek
(based on my past response to similar queries)

Illustrated in this sample:
http://www.savefile.com/files/1945932
Parent to Child AutoCopy Model based on KeyCol Values.xls
(full construct details, nicely rendered, easy to understand n adapt)

Celebrate success, hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"nishkrish" wrote:
i have data in sheet 1 and if the column AG has agent code 1,2,3,4, and so on
i have created different sheets for the agents i want when the data is
inputed in sheet 1 and when column AG is updated the information should be
copied to respective sheet