How can I compile data from several worksheets into one? In other words what
I am asking is how can I take information from different sheets and combine
the total on one sheet. Example:

Sheet 1 thru Sheet 7 all have the same data, but different totals how can I
get another sheet that will show a running total of all sheets?

Colum H
2.00
3.00 All sheets have this column.
28.00

On the last column I need a running tabulation of any amount that is added
on the other sheets.

Thanks