How would one export multi worksheet excel file to a single text file?

I am attempting to use VBA code to export a multi worksheet excel file to a single text file with each worksheet appearing as a separate line in the text file. Any insight would be appreciated.