Hi,

I faced the same issue a while ago. If you have just a couple of Excel files, you can use manual methods like copy-paste or Power Query. But when it comes to bulk merging (hundreds of files or very large sheets), manual methods become very time-consuming and prone to errors. They also struggle with formatting, formulas, and large file sizes.

What worked for me was using a professional tool. I tried the SysTools Excel Merge Tool, which allowed me to combine multiple Excel files into a single workbook or even into one sheet without losing any data. The best part is that it preserves formatting, supports large-sized files, and saves a lot of time compared to manual merging.

If bulk merging is your requirement, I’d definitely recommend going with an automated tool instead of trying to manage it manually.