Consolidate the excel

[yashsrawat]

Hi
I have 5-6 excel with same TAB name on each on them.I want one single excel with same tab where all the data will be extracted from them.

Thanks

 

[hiker95]

yashsrawat,

See if something here will help you get started in the right direction:

WBs to 1 Sheet
https://sites.google.com/a/madrocke.../merge-functions/consolidate-wbs-to-one-sheet