Do you expect that you'll have any cells in the worksheet that might not be
copied (long data entry). If so, copying the worksheet might not work
without doing other things. If it were me, I'd save the file with a new name
and then delete all the worksheets but the one you need.

Do you want to keep the summary page with the original workbook? Or can it
be created as a separate workbook?

There are several approaches that can be taken.

Let us know.
Barb Reinhardt

"marcia2026" wrote:

Each month I create a new folder with a workbook to enter daily activity. At
the end of the month, I run a macro that creates a summary page of all of the
data. I would like to link or copy the summary page to another workbook in
the same folder. What code could I add to accomplish this.?