I have created a log with specific formats including locking the the first
row so that it is always visible, I have a header and footer, etc...

How do I copy everything to another sheet so I don't have to go and reset
all these changes including page set-up like landscape...

Thanks.