copy data from a excel sheet to different excel sheets automaticaaly

hai,
i am beginner in the vba. i am attaching a excel along with this. what i want is to transfer some of the data from data entry sheet to different sheet automatically so that i make reports accordingly. Intention is to avoid reentry of data in different sheets. If someone helps to make this as reality it is very helpful to me. if you are kind enough you do the same in this work sheet and upload to me since i am beginner and i dont know too much about the complexity of this programme. i beg everyone to help me at the earliest so that i can ease my work load and tension free. please help meBook15.xls.
thanking you

hi....FDibbins
thank you so much....i hope this will work 4 me.
i would like ask to one more thing. is it possible to copy certain datas if it the mode is normal in a different sheet and if the mode is fast track to a different sheet
i hope it is more if u go thrugh tha attached worksheet. i hop u get me....
kindly give me a solution for this also. i am very greatful to u....

hi ford...
kind help me to solve the above problem...pls....

hi ford...
pls see the attachment.
i want to keep the certain details of the mode "normal" and "fast track" in two separate sheets as shown in the attachment. That means if the mode is given as normal, the details of "normal" may copy to sheet named as "normal" and if the mode is "fast track" the details may copy to the sheet named as "fast track" automatically.
I hop u get me...Book155.xls

with regards
thanking you
JP

Hi Ford
Thanks a lot...... This is what I exactly want....thanks lot....

with warm Regards
JP