How would I have the Header copied over when I copy the worksheet I've
selected - but in a macro?

I have it now so I click a menu button that's linked to the macro which
copies the worksheet and has very few issues showing up, except the header
is not copying over.

I understand this is how its supposed to happen, but outside of recording a
macro where I'm copying info from one sheet's Header to the other I don't
know what else I can do. Can anyone assist me with this?

Thanks in advance

G