Can anyone tell me if this is possible....

I have a spreadsheet from my supplier that lists all stock items, pricing &
current stock. I also have a spreadsheet showing a selection of items that my
supplier sells but not all. Is it possible to get my suppliers spreadhseet to
update the stock on the items i sell to update automatically rather than me
having to manually go through and change them myself?

Thanks,
Adam.