How do I combine spreadsheets

Hi everyone

I have two spreadsheets (complete with macros) that I need to combine into one sheet. How do I do this??

I tried copying all the sheets across to a new book but everything wanted to reference back to the originals, also wouldn't let me save it so I could clean it up later...

There must be an easy way.......

Many thanks

Dave

Thanks for the reply

I need everything t be combined into the one book, data, formate and macros.

Cheers