Using Excel 2002, I have a bunch of workbooks that deal with related
topics. Within each there are a few worksheets.

I would like to consolidate all of the workbooks into one. However, I
can't see any way to do this.

Is there a way?

Musawwir Spiegel

One way.
Open the main book and open the others using the normal menu <file<open
Use <windows<arrange<cascade
and drag each sheet into the main workbook. Just click and drag the tabs.You
may want to rename the sheets as you go.

If you have too many books, open them in blocks of 8 at a time.


--
Greetings from New Zealand

"Musawwir Spiegel" wrote in message
...
Using Excel 2002, I have a bunch of workbooks that deal with related
topics. Within each there are a few worksheets.

I would like to consolidate all of the workbooks into one. However, I
can't see any way to do this.

Is there a way?

Musawwir Spiegel