Hi All,

I have multiple files and each of them may have multiple tabs. Each tab is in the same data layout.

Say Column A to Column E

I am looking for a VB Code that can consolidate the files/tabs into one single file / tab. When I run the VB code, it will prompt for an open file dialogue so I can select new file(s).
Then the VB will append the new data to the existing tab.

I appreciate if anyone can help on this. Thanks….