I have finally gotten worksheet number one to look exactly like it should.
Is it now pozzible to write a macro that will input certain cells from this
sheet (a new one created every day, with a different name) into a summary
workbook that I created?

for example
Workbook Name = Open 1-25
Summary Work Sheet = Orders Pending Master Record 2008

The master record records the values summarized in the daily report. Is
there a way to copy this information automatically from the daily report to
the master record?

Things to consider:
The values on Open 1-25 will only be copied into the master record cells for
January 25th, the macro would need to account for the same cell inthe daily
report being copied into a new destination cell.

I will be weatching this post closeley, please reply with questions if you
need clarification. Thatnks for all of your help.