Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet?

I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet.




We have a finance form that will submit vendor, invoice, amount etc. in to our sheet.  My question is how can I get the information in the form to fall under the appropriate vendor?

Right now, the form information goes to the bottom of the sheet and I know that you can set it for the top of the