I open the file, add a column "A", double click on the sheet name, hit <cntl> "C", move to cell A2, hit <cntl> "V", hit <cntl> "C", move over to cell B2, hit <end> and the down arrow, move over to cell "A596" (or whatever it is), hold down the <shift> key, hit <end> and the up arrow, the move the cursor down to "A3" and hit <enter>. Then I put the cursor on "A2", hold the <shift> key down and go to the end of the data ("F596" or something like that) and hit <cntl> "C". Finally I go to an aggregate workbook and put the cursor on the next blank "A" cell ("A2" the first time, "A598" the second, etc.) and hit <enter>. Then I save the first file and close it.
Repeating this 70 times is more than a touch tedious. Can anyone think of a reasonable way to automate it? When I tried to record a macro, it didn't understand the double click on the sheet name step and crashed.