Enter data in one worksheet and have it copy to another worsheet
 

I want to enter data in one worksheet and have it copy and or edit
automatically to another worsksheet in the same workbook. I could do it in
Excel 2003 but cannot figure out how in 2007.