I need exactly what you provide me in the first link(demo.xls)

I am uploading my original file where I need to get this formula work (bigger file cannot upload in the forum so providing a link)
http://www.sendspace.com/file/wt9e6a

Please make this(demo.xls) formula work in my sheet,I would be highly obliged to you if you get my work done.

Only focus on three sheet named are> “all creadit” ,” sny” , “gul”(tab colored RED)
when i write anything in all creadit for sny, it automatically should transfer into sny sheet

and same for gul

and when i clear anything from main sheet for sny it should be removed from sny sheet

and same for gul