How would one code a case statement in Excel VBA to do the following?

I am attempting to export excel spreadsheets to text files using different file layouts based on the information in the spreadsheet being exported. I have a total of five spreadsheets. My feeble attempts at using a case statement for this, have led to little more than a spike in my blood pressure. Any insight/examples of this would be appreciated.