Find data in another spreadsheet

Hello,

I need my stock checker to pick up data from our suppliers spreadsheet which they change daily.

So what i need for example is:

To match the stock - Find item code eg the text AA001 in column A of suppliers spreadsheet, lets just say that is on row 5

To bring in the data to our spreadsheet- From the same row that AA001 appears in use data that appears in column C, so find AA001 then our column d=row 5 column c

THEIR SPREADSHEET

A B C
ROW 5 AA001 | APPLE | IN STOCK |

OUR SPREADSHEET

A B C D
ROW 1O AAOO1 | APPLE | PRICE | STATUS


The suppliers add and remove items to their spreadsheet so we need ours to search and find the data as opposed to exactly matching to a permanent cell.


Hope this makes sense!
Is this possible and how would the formula read?

Many thanks!