How would I make a workbook where the first sheet VSTACKS data from all subsequent sheets and then sorts them by column?

Basically, I have a workbook with separate sheets for separate clients, and each sheet has part numbers in it.

I want one sheet to summarize all the part numbers in the subsequent sheets. Basically, the VSTACK function to add the following sheets.

But where my design gets complicated is this: I want to be able to add a new sheet (basically, create a new customer) and have that new sheet dynamically included in the summary sheet. I.e., I don't want to re-write the VSTACK formula each time I add a new sheet because that will just end up with mistakes being made.

Is there a way to dynamically capture ALL following sheets in VSTACK?

And second, in the summary sheet, how can I sort the data by a criteria other than listing it in the order of the sheet it appears in? So in other words, I want to summary page to sort by part number, regardless of what customer's sheet it appears in.

Thank you so much!