Form to Summary - Automatically
 

Hello everyone! I know you can help me because you have in the past.

I am creating several forms in an Excel, version 2003, Workbook in which an
individual will complete, then I want each of the 'text boxes' that have text
in them to automatically populate into a 'Summary' worksheet. Please help?

For example, the question on the form to complete is 'What key experiences
have been gained, goals have been achieved, or accomplishments/actions have
exceeded expectations?' There is a textbox next to it that the individual
can type up to 600 characters.

I am trying to get the text typed in the box to automatically illustrate on
the Summary Tab.

So, after the individual completes all 5 separate forms, the summary tab is
automatically updated for one place to read all of the information entered.

Make sense?

Thank you in advance for your help!!

Fitzi