I have a workbook that contains about 100 worksheets, all with exactly the same columns but different numbers of rows. I want to combine them into a single worksheet with the same columns but all the rows, with the sheet name as a seperator row between the rows from each sheet. How can I do this? I do not know visual basic, though I know some BASIC and c, and I don't want to take the time right now to learn a new programming language. What can I do? Is there some existing feature or function I don't know about? It seems like an obvious thing to want to do...

I use Excel X for the Macintosh.