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.
Please suggest solution for this problem. Sample snapshots are attached here. Sheet names are not fixed.

Thanks
Pradeep S. Walse

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Consolidate data from different sheets in one sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[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 same query on 'Excel forum' website. I am not aware how to copy link from this website.

Hope now my post will be approved.

Please let me know, if anything to be done for approving this post. I am ready to delete post from 'Excel forum' website.

Waiting for reply from your side.

Thanks,

Pradeep