Macro Merge Particular sheet from multiple workbook

[bijeshbest]

Hi there

Could you please help me here

I need to merge particular sheet "Consolidated data" from the different work book saved in the same folder to another work book without formulas. Save as values.

 

[alansidman]

Look at Power Query which allow you to merge tables or append tables. No VBA required. No formulas required. All done in the U/I.

 

[bijeshbest]

It worked for me.. Thanks a lot.. I created one excel with multiple sheets for each resource.. and fetched data with help of power query.. DATA Existing connections.. and combined all these data with help of below Vba code