How to create extra Excel sheets showing data sorted differently

I have an Excel spreadsheet with around 10 columns and 100 rows...

Depending on context, I want to see the data in different orders, e.g.

• Scenario A
  
  
  
  • Sort spreadsheet by Column 1
  
  


• Scenario B
  
  
  
  • Sort spreadsheet by Column 3, 6, 2 (descending)
  
  


• Scenario C
  
  
  
  • Sort spreadsheet by Column 1, 2, 4, 3
  
  

etc...

It's driving me nuts keeping changing the sort order...

Is there a way to create additional Sheets that each show the data from the first sheet, just sorted in different orders

Then I could have sheets called e.g.

• Master Data


• Scenario A


• Scenario B


• Scenario C