Combining daily reports into a month end

[ERcoder]

Each day we have an excel file with a list of patients seen that day.

At the end of the month how do I combine all those files into on file for a list of all patients seen during the month.

Thanks for any suggestions.

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx