Dear Sir, I have 300 daily sales report excel files, I wanted to combine them into one using VBA how to do that ? please advice.