I have 7 customer service reps that take inbound calls.  I need each of them
to use a call log sheet on Excel and then I want to be able to consolidate
the data from all 7 call logs into one master spreadsheet.  The data on the
master should update automatically from the information entered on the
individual sheets, including formatting and inserting or deleting of rows.  I
have tried using Import External Data which worked well in theory but would
not keep the format of the merged cells.  I am using Excel 2003.  If someone
knows of an easy way to accomplish this it would be greatly appreciated.