Consolidation of Multiple Excel Sheets

[ravi2628]

Hi

i have more than 50 workbooks with same data but i need specified columns in one workbook

example sharing for your Reference

[Crazy Mart]-Workbook1

Item Name	Price
Oranges	50
Apples	35
Banana	25
Pomegranate	60

[Trail Mart]-Workbook2

Item Name	Price
Oranges	85
Apples	35
Banana	60
Pomegranate	74

Output

Item Name	Crazy Mart[Workbook Name to be placed]	Trail Mart[Workbook Name to be placed]
Oranges	50	85
Apples	35	35
Banana	25	60
Pomegranate	60	74

Thanks in advance for Help.

Thanks & Regards,
Ravi

 

[My Aswer Is This]

Your subject title says:

Consolidation of Multiple Excel Sheets

But then you said:
i have more than 50 workbooks​

So are we dealing with 50 sheets in one workbook.
Or 50 sheets in 50 different workbooks?

 

[ravi2628]

50 workbooks into 1 workbook required

 

[My Aswer Is This]

We would need a lot more information.

Like what are the names of the 50 Workbooks.
What is the name of the sheet in these 50 workbooks.

 

[ravi2628]

1)50 Workbooks name may change
2)Comman Sheet Name in all 50 workbooks