I have created a Macro to copy from page 1 and create & paste into page 2 all contents.

When I run the macro, I will find the contents in page 2 & 3

And, if i run it again, it will create two more pages, BUT, BLANK with the header and footer from page 1.

How can I figure this out?