Hello from Steve Dee

Below is on Sheet 1 would like a formula on Sheet 2
Ok I want a lookup please that would copy the data in Col C to Sheet 2

A B C
1 Orewa Man 17/223 11
2 Man 22/240 2
3 Man SG240 7
4 Nissan SCORP-SLF180 6

Thankyou.