Merging/Combining Multiple workbook to One

[vs.suresh]

Hello Team,

I have a requirement of merging/combining multiple workbook to one workbook with limited columns.
Each workbook has it's own heading and own column alignment but all the workbooks has the same required data. Can someone help to do it with either powerquery or vb scripts.
I have attached sample sheets and also result sheet.

Regards,
Suresh

[PeteABC123]

Hi vs.suresh:

You can use the power query feature to assemble a pivot table which will draw from numerous workbooks.

A Google search yielded this method which is well outlined. Seeing that you're using Office-Excel 2013, there's a link to an add-on near the top which will facilitate the method therein contained.
https://excelchamps.com/blog/pivot-table-multiple-files/

Once your pivot table is up and running, drag, drop, and summarize as needed.

Pete

[vs.suresh]

Hi vs.suresh:

You can use the power query feature to assemble a pivot table which will draw from numerous workbooks.

A Google search yielded this method which is well outlined. Seeing that you're using Office-Excel 2013, there's a link to an add-on near the top which will facilitate the method therein contained.
https://excelchamps.com/blog/pivot-table-multiple-files/

Once your pivot table is up and running, drag, drop, and summarize as needed.

Pete

Hello Pete,
I'm using Office 365

[vs.suresh]

Pete,
I have gone thru the link you have provided. The problem is the data in all the excel workbook is not as same. But there are similar data across the workbook which i need to combine..

[PeteABC123]

vs.suresh:

The column headers need to be the same in each workbook to use it, but you figured that out.

Maybe one of the real propeller heads here could provide a workable solution.

Pete

[vs.suresh]

Any solution from others?

[vs.suresh]

Hello Team,
I thought it might be a simple way of doing it...

I know which columns need to be imported.. Any solutions?

Regards,
Suresh

[vs.suresh]

No solution?? Can we do it with helper columns?

[PeteABC123]

Hi vs.suresh:
The column headings and cell locations have to be the same in each worksheet field. If helper columns can carry the data to the same spots, that would definitely be a huge plus.