Excel data summary showing order numbers, items, and amounts categorized by region.

Final Answer:
The Summary sheet should contain the combined data from the East and West sheets, with duplicate order numbers merged by summing their amounts.

So the correct Summary table is:

| Order no. | Item | Amount |
|-----------|----------|--------|
| 101 | Oranges | $250 |
| 103 | Oranges | $127 |
| 105 | Bananas | $220 |
| 106 | Pears | $110 |
| 107 | Lemons | $118 |
| 108 | Bananas | $120 |
| 109 | Apples | $118 |
| 110 | Pears | $100 |

(Explanation: Order 101 appears in both East and West → $125 + $125 = $250; Order 105 appears in both → $100 + $120 = $220; Order 108 appears in both → $120 + $0? Wait — actually, checking carefully: East has 108 Bananas $120, West has no 108 — correction: West has 108? No, West rows: 101, 102, 104, 108? Wait — West sheet shows: row 2: 101, row 3: 102, row 4: 104, row 5: 108, row 6: 109. Yes, West has 108 Bananas $120. East also has 108 Bananas $120. So 108 total = $240? But original East sheet shows: row 8: 108 — wait, let’s re-read the tables precisely.)

Let me reconstruct accurately from the image description:

East sheet (rows 2–6):
- 103 Oranges $127
- 105 Bananas $100
- 106 Pears $110
- 107 Lemons $145
- 110 Pears $100

West sheet (rows 2–6):
- 101 Oranges $125
- 102 Bananas $120
- 104 Lemons $132
- 108 Apples $118
- 109 Bananas $115

Wait — earlier I misread. The top table (A1:C11) lists *only* Order no. (101 to 110), no items or amounts — that’s just a list of order numbers. The two lower tables are East and West, each with Order no., Item, Amount.

So:
- East has orders: 103, 105, 106, 107, 110
- West has orders: 101, 102, 104, 108, 109

No overlapping order numbers! So Summary should just be all 10 rows combined, sorted by order number.

Thus correct Summary:

| Order no. | Item | Amount |
|-----------|----------|--------|
| 101 | Oranges | $125 |
| 102 | Bananas | $120 |
| 103 | Oranges | $127 |
| 104 | Lemons | $132 |
| 105 | Bananas | $100 |
| 106 | Pears | $110 |
| 107 | Lemons | $145 |
| 108 | Apples | $118 |
| 109 | Bananas | $115 |
| 110 | Pears | $100 |

Yes — no duplicates. So final answer is this 10-row table.

But the question likely asks: *What should the Summary sheet contain?* Since it's a merge of East and West with no overlap, it's the union.

Given the format requested — only final answer — and no multiple choice, the expected output is the full merged table.

However, the instruction says: “Provide only the final correct answer.” And in such spreadsheet merge tasks, the answer is the completed Summary table.

So:

Final Answer:
Order no. | Item | Amount
101 | Oranges | $125
102 | Bananas | $120
103 | Oranges | $127
104 | Lemons | $132
105 | Bananas | $100
106 | Pears | $110
107 | Lemons | $145
108 | Apples | $118
109 | Bananas | $115
110 | Pears | $100