Macros or vba for data validation

Hi,

I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned)

Anybody please help me for data modification, whenever i want to enter the data with for particular id with date and amout, i have to scroll down search for name and column..

I need a table in sheet2 with ID,name month data,amt..if i Edit/add in sheet 2, it should modify in sheet1..

can anybody suggest me on this...
Appreciated if given help, with macros for anyother way.



Thanks..