See
http://www.rondebruin.nl/fso.htm

There is a macro example to copy a sheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"dbguy11" wrote in message ...
I have several single sheeted workbooks that I need to merge into one file
and still maintaining each worksheet into its own tab. I use to have an
add-in or macro but lost it when I got a new pc.

Thanks in advance.