Have a workbook with 6 sheets.
Sheet 1 of original workbook contains data that is referenced in the top 5 rows of the other 5 worksheets.
Data is entered during a week in the other rows in 4 of the other worksheets (fifth worksheet is a summary of all the others).
Want to start a new workbook each week - with only the data on sheet 1 carried forward into the new 6 worksheet workbook.
What is the best way to accomplish the task?