How can I creat a combined sheet using the data in other sheets?

[Guest]

I have a book which contains a company's sales information in different
areas. For example, the book has three sheets. Sheet "Europe", "Asia", and
"Africa" contain the salesmen' contract amount and value in different areas.

In each separate sheet, I can quickly know the salesmen's achievements in
ascent order or descend order in this area.

Now, I want to have a combined sheet which contains all the salesmen's
contract information. However, the combined sheet share the same source data
with other three sheets. And in this combined sheet, I can quickly display
all the salesmen's achievements globally.

How can I do?

 

[Debra Dalgleish]

Instead of using separate sheets, you could store all the data on one
worksheet, and add a new column that indicates the region.

Then, you can use an AutoFilter to display the records for one region
(Data>Filter>AutoFilter). There are instructions in Excel's help, and here:
http://www.contextures.com/xlautofilter01.html

Or summarize the data with a pivot table, for different views of the
data. There are instructions and links here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm