Combining worksheets/tables into one consolidated table (or pivot
 

Greetings!

I would very much appreciate any information on the following ASKs. Thanks
in advance!

ASKs
-How to create a pivot table from mutiple tables (multiple sheets within the
same work book).
-How to grab the label contents of a tab (within a pivot table)

I'm trying to avoid all of this programatically (macro) but if that is what
it takes then I can write some VB.

I tried using the multiple consolidated pivot view but it's quite crude and
makes no sense to me.

I'm just looking for something like:

Worksheet1:
OrderNo Qty
1 10
2 1

Worksheet2:
OrderNo Qty
3 5
4 2

Cosolidated view (Table or Pivot Table):
OrderNo Qty
1 10
2 1
3 5
4 2


Thanks!