How to combine tabs from 1 workbook into another workbook

[Launchnet]

Hi Everyone

I have 3 workbooks with multiple spreadsheets (tabs) in each workbook.

I want to open a blank workbook and copy various sheet tabs from the other workbooks into my new workbook.

I need to keep the formatting etc when these are copied over. There are text boxes in some of the existing workbooks and macro's.

Sure would like some help.

Thanks Matt

[Mallycat]

Why don't you just do it? Not sure if I have missed something

[Launchnet]

You said . . . Just Do It.

Well, I tried every way of copying and pasting that I could think of and something was always missing.

After your comment, I decided to try again.

I copied all and went to the new workbook and clicked on Insert copied cells and it worked.

Thanks for making me think.

Matt