How to have sheet2 data in sheet1 table not move when using sort column function

So I have order data in sheet 2 that needs to total up into corresponding data in sheet 1.

Every order in sheet 2 gets an account #, and that acc# corresponds to a specific row on Sheet 1, but the actual total calculation goes into a different column of that same row.

Currently, i can get the function to work so long as i dont use the sort header tool which is not ideal since sometimes i need to sort by volume high/low, account name a-b, and so forth.

How do i make it so the sum tracker for each account stays in the corresponding row no matter which row the account ends up in?