saving data in different sheets

[jillibillijames]

Hi,

I renamed four sheets (Sheet2 to Sheet5) with different names. In sheet1 i gave data validation with the sheet names. when i enter data for the feilds like "value and date" in sheet1 by selecting a particular sheet name in sheet1, the data should entered should be pasted in that paticular sheet. Whenever i enter the data it should save in the next row for the sheet name selected.

Thank you very much in advance for help

Regards
James