Auto sort a column and auto duplicate all sheets to one sheet

*** THIS PROJECT IS FOR GOOGLE SPREADSHEET ONLY *** 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 (automatically): | 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. Sheet 1 comes at top then sheet 2 under it and so forth. I just need the way to do it. No need for anything else. I hope that I am clear enough.