VLOOKUP Trying to get cells to Auto populate values using Data from another worksheet.

Hi

Need a formula that populates data from another sheet in the same workbook.

Example...

A B
1 1001 Tesco

Imagine that the data in cells A1 and B1 are in a report on a different worksheet in the same format. I want when I enter 1001 into Cell A1, cell B1 to then Autopopulate Tesco by pulling the Data from the other worksheet.

Thanks
Greg

Please attach a sample workbook