Or use Pivot Table.
No formulas or VBA needed.
You can convert 20 sheets with
odd sized tables at odd locations
into one list.
http://www.freefilehosting.net/download/3b5gk