How to automate saving and merging daily Excel files into a master spreadsheet?

Reposted From https://www.sqlmessenger.com/faqview.html?id=576
Q: Some colleagues send me Excel files daily. My task is to save them to a designated folder (for archiving and future reference)...