worksheets

[marci]

Hi:
I have one workbook that contains 4 worksheets and I need to create a 5th
worksheet
(in the same workbook) that will contain the other 4. I want to be able to
update the 4 individual worksheets and have the info automatically updated
on the 5th worksheet. I have tried to look this up in Excel Help and on the
MS website but I don't know if it is found under linking or another term
that I'm not familiar with.

Thanks ~

 

[Frank Kabel]

Hi
how should the data be combined on the 5th sheet (summed?)

 

[marci]

Sorry, I replied only to your address and not the group.
Anyway, the 5th sheet is for information purposes only and
it will contain the other 4 worksheets (not combined). I
don't need any sum totals or averages, just a transfer
of info.I want to be able to update the 4 worksheets
separately but have the info on the 5th sheet corrected
from that action.
I know it can be done becuase we have some worksheets
that were created in my office but not by myself or anyone
still employed here. Hope you can help. Thanks ~

 

[marci]

BELOW would be best

thanks ~

Hi
still not sure how the combined data should be displayed?
- below each other
- next to each other

 

[Frank Kabel]

Hi
still not sure how the combined data should be displayed?
- below each other
- next to each other