Updating sheet data

Ive got a smartsheet im setting up for inventory management. Fairly new to smartsheet but have a handle on the basics. My question is this:

Lets say once a month several vendors send me their inventory update in an excel. Is there some way to automate adjusting the values in the sheet? all the info in a row would be fixed and just the qty on hand field needs updated. There may sometimes be entirely new rows as well.