How to merge different workbooks in excel using macros ?

[Shraddha]

How to merge different workbooks using macros in one single workbook

 

[GraH - Guido]

Hi, Shraddha, does it needs to be a macro?
Alternatively Power Query/Get&Transform can be considered.

 

[Marc L]

Consolidate data from different excel files (VBA) …​

 

[Chihiro]

This largely depends on how your workbooks are structured.

If your data sets are all flat table and stored in single sheet of each workbook... it's very simple. Using code, PowerQuery, MS Query or any other means.

If after following Marc L's link, you are unable to solve the issue...

I'd suggest uploading sample workbooks, couple of your source file (with sanitized data, but keeping exact structure and data type) and how you want the merged output to look like.