Hi there, I understand clearly the two things you need on your Google Spreadsheet, that is auto sort of all columns when first column is sorted, and auto updating of the last sheet whenever any of the seven sheets are updated.
I'll send you a sample Google Spreadsheet where I will do these two things, and then you can use the logic I used for your sheet. Or, I could do it for you.
Regards,
Swati