Sort Data into new spreadsheet based on cell value
 

Hi all
I am stumped on this one. I need to create a new spreadsheet based on the main data spreadsheet (see attached example). I need to sort based on a non-blank cell in column E then further sort that based on non - blank cells in columns F to AP.
I than need to create another new spreadsheet (report) for each column.
I'd like this to be automated so that I don't have to do anything complicated each time I need this data.
I hope that makes sense.
Please help!