Specifying row number in formula

Hello all,

Please help~

I want to do as the following:

In sheet 1 I have all the data needed for sheet 2, organizing in row, which means for a particular cargo, its details will be all having same row number

Cargo A data 1 data 2 data 3 ....... and so on
Cargo B data 1 data 2 data 3 ....... and so on

In sheet 2, I have a form in which I wish to have it auto fill in the cargo particular by inserting in just the row number for the cargo in sheet 1.

Cargo A

data 1 =Sheet1!A#

data 2 =Sheet1!B#

data 3 =Sheet1!C#

"Cargo A is row 2, then # should be substitue with 2"

I wish to have a way effectively changing the row number for each formula.

Hope this is not a confusing explanation for you all... Please HELP!