I have a workbook in excel with four sheets, i have the same format of
columns in each of the sheets except for the last one. The last one i am
trying to make be the total of the others. this brings me to my question, how
can i make the columns in the final sheet be updated with whats put in the
other sheets?

My first four sheets are my salesmens statistics, each sheet being a
different salesman. I want the final sheet to be a total sheet that adds
copys the info from the other sheets to the final. For instance i have a
column for revenue, organization name, potential revenue, etc, on each sheet
including the final sheet. i want the final sheet to stay updated as the
other sheets are updated.

PLEAS HELP!!!