How do I extract all Sheet names

[dano_1352]

I have a workbook with 40 or so worksheet tabs in it. How do I extract the names of these different tabs into, lets say Column A?? Anyone??

 

[ZSandman]

Adam: Not at all, the more the merrier (from my perspective anyway). I was kind of butting in myself.

Bingo, this code works like a charm. Thanks.

Sandman

 

[ZSandman]

Jonmo: Yes, thanks, that's much simpler. I use that for smaller spreadsheets, but find that when others have to use a spreadsheet with 40+ tabs, an index page is helpful where I've grouped the tab names by subject, put boxes around them etc. When I hit 150 tabs, I find that even if I created the spreadsheet, it gets a bit daunting when you back a year later and try to recall tab names. Nevertheless, your suggested approach is definitely better for most spreadsheets. Thanks.
Sandman