Copy Specified Columns from Multiple Workbooks to one Workbook

[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

<tbody>
</tbody>

[Trail Mart]-Workbook2

Item Name	Price
Oranges	85
Apples	35
Banana	60
Pomegranate	74

<tbody>
</tbody>

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

<tbody>
</tbody>

Thanks in advance for Help.

Thanks & Regards,
Ravi