Overview

The OP basically wants to be able to use the spreadsheet functions over the original data without having to scroll across a large number of rows and columns. His background make him think about having custom views and a easy way to change from one to another but Google Sheets doesn't have a built in feature to manage custom views.

Fortunately the fourth requirements are doable by using built-in features and Google Apps Script

Rows could be hidden by using filters but columns only could be hidden manually or by using code.

For 1, and 2 use Google Apps Script to create custom menus that apply the hide/show columns and optionally rows over the "master sheet". This will allow the user to edit the data directly over the "master sheet" and sort it.

Code example

The following code creates a menu for handling the hide/show operations of columns specified in a global variable.

var cols = [1,5,7]; //columns to be hidden/shown

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [ 
    {name: "Hide", functionName: "hideCols"},
    {name: "Show", functionName: "showCols"}
    ];
  ss.addMenu("Custom Views", menuEntries);
}

function hideCols() {
  var sheet = SpreadsheetApp.getActiveSheet();
  cols.forEach( function(col) {
      sheet.hideColumns(col);
    }
  )
}

function showCols() {
  var sheet = SpreadsheetApp.getActiveSheet();
  cols.forEach( function(col) {
      sheet.showColumns(col);
    }
  )
}

You can achieve this by using an array of importrange() functions. This cannot import the formatting information, which is not possible without Apps Script, but it will pull in multiple sheets and aggregate them into one list, which you can then sort with an additional formula. Keep in mind that each imported sheet will have to have the same number of columns. For example, if you have four sheets to import with 4 columns each, the import formula will be as follows:

={
importrange("url_to_sheet_1", "Approved!$A:$D");
importrange("url_to_sheet_2", "Approved!$A:$D");
importrange("url_to_sheet_3", "Approved!$A:$D");
importrange("url_to_sheet_4", "Approved!$A:$D")
}