Experiment with some random data and check if you are getting the desired result using the macro. We hope the tutorial was easy to understand and that you can merge Excel Files and Sheets.