Consolidate data from different sheets in one sheet

Hi,

I have some data in 8-10 worksheets in all 20 excel file. I want to list this data on separate sheet in same file or separate excel file. I tried with ‘consolidate’ command but it didn’t worked for me.
I want to list data appeared below 'Long Description (Size)' heading from all sheets in one sheet in same file or separate excel file.
Please suggest solution for this problem. Sample excel file is attached here. Sheet names are not fixed.

Reagrds,
Pradeep S. Walse