Can someone give me some pointers on this Excel question when it comes to linking data between worksheets in the same document?

I have an Excel 2003 workbook with three worksheets. I want my users to be able to insert information in two of the worksheets. My question is: is it possible to have the text that is inserted in the two worksheets automatically populate the third worksheet. I don't want my users to have to input the information two times.

I know I can hit = then click on the cell and the contents in the cell will appear in the other worksheet. But my worksheets contains several columns where information can be entered. If a user inserts information on the same line and several columns, can all of this text populate the other worksheet? I imagine there is some VB coding that will take place.

Any information would be great, thanks! -Jason