Merging Excel worksheets into one

Merging Excel worksheets into one

How do you merge multiple Excel worksheets into one without losing/overwriting data? I have been given the task of taking the daily logs at my workplace and combining them into a monthly log. Each daily sheet is in its own file. Is there an easier (and quicker!) way other than copy/paste each sheet? I want to say I saw a method for this ages ago, but for the life of me cannot remember how to do so now! We use Excel 2003 in case that makes any difference!