Thread: Copy & paste sheet from today's file into tommorow's file

I'd love to have this automated with some code if possible and appreciate any help with it:

I have a file structure set up as follows:
Folders for each month:
H:\Morning Reports 2011\Jul
Within each folder, daily files named
7-1-11.xls, and so on for the entire month
Within each file, there is a sheet called “Production” and “Tommorow’s”.
At the end of each day I save the current file,copy the “tomorrows” sheet of the current day, open the file for the following day, Paste the clipboard contents( previously copied) into the “Production” sheet and save,then close. I then close the file from the previous day.
I need to answer No to all update prompts, and yes to any save prompts.
Thanks again for sharing your expertise..
*