When I copy a set of worksheets from one workbook to another the macros don't
follow.

Let me Explain:

I copy worksheets from workbook A into workbook B and close workbook A.
Then from workbook B I select the command button to run a macro. What
happens is workbook A opens again and runs the macro. If I break the link
with workbook A in workbook B using Edit/Links the command button doesn't do
anything.

How can I move the worksheets into the new workbook and have them behave as
they did originally?

Thanks