I have approximately 50 different excel files I need to turn into one file. Is there a way to do that? I am not sure if I should be saying merge, or combine, or convert...what I need to do is have all the data that is in 50 separate excel files somehow now be in one excel file. If I can't find a method for doing that, I will simply copy/paste from each file into one very large file. However, I am thinking you guys probably have a formula or method for doing that?