So yeah the title speaks for itself. I am looking to do 2 things in Google Spreadsheet because I am entering data from a different third party app using Google API.

First, I need Google Spreadsheet to auto sort a column I specify with it's rows So for example, this

   | A    | B
=====================
 1 | This is | 22
 2 | Is      | 33
 3 | A Test  | 44

Should look like this when sorting column A:

   | A    | B
=====================
 1 | A Test  | 44
 2 | Is      | 33
 3 | This is | 22

Second,

I have 7 sheets in the same workbook and they all carry the same format and data type. I want them to be automatically copied (duplicated) as is to an 8th sheet so when ever I add any data in, for example, sheet 1, it automatically be add to the last sheet, which will be containing all the data from all the sheets in the workbook.

I hope that I am clear enough.

Thank you in advance.

The title speaks for itself. I am looking to do two things in Google Sheets, because I am entering data from a different third-party app using Google API.

First:

I need Google Sheets to auto sort a column I specify with it's rows. So for example, this:

   | A       | B
=====================
 1 | This is | 22
 2 | Is      | 33
 3 | A Test  | 44

Should look like this when sorting column A:

   | A       | B
=====================
 1 | A Test  | 44
 2 | Is      | 33
 3 | This is | 22

Second:

I have 7 sheets in the same workbook and they all carry the same format and data type. I want them to be automatically copied (duplicated) as is to an 8th sheet, so whenever I add any data in, for example, sheet 1, it automatically be add to the last sheet, which will be containing all the data from all the sheets in the workbook.

I hope that I am clear enough.