Hi,

I have two spreadsheets with about 30 sheet tabs in each of them.

Is there a simple way to merge the 30 sheet tabs of one file into the
other so I'm left with one file of 60 tabs?

I know you can copy one sheet to another workbook by right-clicking the
tab and selecting "Move or copy" and then selecting the book you want
to copy the tab into, but is there a simple way to merge every sheet at
once or by macro?

Any help would be much appreciated.

Thanks,

Kim