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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item Name[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Pomegranate[/TD]
[TD]60
[/TD]
[/TR]
</tbody>[/TABLE]

[Trail Mart]-Workbook2

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item Name[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]Pomegranate[/TD]
[TD]74[/TD]
[/TR]
</tbody>[/TABLE]


Output

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item Name[/TD]
[TD]Crazy Mart[Workbook Name to be placed][/TD]
[TD]Trail Mart[Workbook Name to be placed][/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]50
[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]35[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]25[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]Pomegranate[/TD]
[TD]60[/TD]
[TD]74[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance for Help.

Thanks & Regards,
Ravi