Maybe just copy the whole sheet?

edit|move or copy sheet
(check that box at the bottom)

Or you can ctrl-click the worksheet tab and drag to its new copied location.

lbierer wrote:

How can I transfer columns and headers from several worksheets to another
with out having to copy and paste everything?

--

Dave Peterson