Exporting From A Workbook

I was wondering if there is a way to export specific data from the workbook into a text document. I would want it to extract each worksheet name, and the contents of 2 specific cells.

So the text document would look something like this:

Sheet1name ContentsofCellM1 ContentsofCellN1
Sheet2name ContentsofCellM1 ContentsofCellN1
Sheet3name ContentsofCellM1 ContentsofCellN1
Sheet4name ContentsofCellM1 ContentsofCellN1

And so on for each worksheet.

Or if a text document can't be done, just create a new worksheet with the above extraction.