One of my jobs is to update data like sales, production, and inventory each day. I also keep up a daily page-long report highlighting stats for each day. What I want to do is have this report automatically update with the new information each day instead of having to go into the report worksheet and change which cells I want to have copied. Thanks for any help in advance.