Generating multiple text files from multiple XL columns

1) I have a workbook with multiple sheets in it.
2) Those multiple sheets are having multiple columns.
3) I have one column in each sheet which is concatenation of all the other columns.
4) Now, I want to extract that concatenated column to a text file with the same name as sheet name.
5) The way I want is I just press one button and it should look for all the tabs, extract that column (say concatenated column is AA) from each sheet, put that into a text file, name the text file same as sheet name and store in some directory on my desktop say H drive.