Need help tallying up certain workbook data

Not sure where to ask this question so here I am. I am mostly an Excel novice with abilities to create basic sheets, and have created a 10 sheet workbook. I need help creating a summary sheet that will search certain workbook columns for all member names, and the items assigned to those names, and then create an alphabetized summary listing of names and assignments.

I have attached the workbook, so I can be more specific.

Look at the sheet labeled "Assigned"

On this new "Assigned" sheet I want to show all names alpha sorted by last name from all columns labeled "Owner" from every other sheet. If a new name in inputted under "Owner" on any sheet then I want that it to automatically show up in the Assigned sheet under the column labeled "Member". For multiple entries of the same name I only want one entry for that name on the Assigned sheet.

Now I also need automatic tallying of all the "Stand #" columns from all sheets to show all specific "Assigned Stands" for each Member. I have manually entered a John Smith example of what I am trying to automatically accomplish on the Assigned sheet.

Any help will be greatly appreciated.