Need macro code

Johnzz Posts 2 Registration date Thursday January 22, 2015 Status Member Last seen January 22, 2015 - Jan 22, 2015 at 02:43 AM

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.