Consolidate data from different sheets in one sheet

[pradeepswalse]

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

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[pradeepswalse]

Hi,

Thanks for providing information about cross posting rules. I was not aware about his rule. Sorry for the inconvenience for the same.

I have posted it on mrexcel forum. I am trying to copy link here. But if I copy link here then not able to post the reply.
Please refer below link for post in other forum.

mrexcel.com/board/threads/consolidate-data-from-different-sheets-in-one-sheet.1169662

Hope now my post will be approved.

Please let me know.

Thanks,
Pradeep

[JeteMc]

As you are using the 2013 version of Excel, you are able to freely download Power Query from Microsoft.
You could then convert the ranges to Excel tables and use Power Query to make a single table as described in the video tutorial by an instructor at Highline College (linked below).
I would suggest that you start watching from the beginning of the video however the method of appending tables explained starting at the 3:56 mark may be of the most help with the file attached to post #1.
https://www.youtube.com/watch?v=sb0hmwiFM-E&t=6s