Duplicated Date from Sheet 1 to Sheet 2

Hi,
I'm looking to find out the best way to automatically update data in sheet 2 from sheet 1.

Sheet 1 will be used to list customers, their contract numbers and progress of jobs, whereas sheet 2 will be used for billing info. I would like the customers and contract number to automatically appear in sheet 2 when it has been entered into sheet 1.

Example:

Sheet 1

Col A Col B Col C
Contract No Name Status
PC00001 Blair Job on Hold

Sheet 2

Col A Col B Col C
Contract No Name Invoice Amount
PC00001 Blair £100

Hi gillian1986, hopefully this will show you how to link your data.
Just type the Contract No. onto the invoice sheet and it will look up the info from sheet 1.

I've entered numbers PC00001, PC00002, PC00003 to choose from.