Linking formuals

[smufficator]

I have two spreadsheets, the first is a table of info, the second is an invoice that is sent out to clients. I want to be able to link the two so that when I enter in a new record on the first table, it will generate a matching invoice using the new input - I know how to link the two, (Sheet1!C2), but I want the information on the second spread sheet, the invoice, to correspond to the row that I am currently using without me having to physically change the row number in each cell on the second sheet - like instead of having Sheet1!C2, i want the cell number to automatically change as I switch rows on the information spread, from like C2 to C3 to C4, without me having to change the number manually or copy and paste each time... I want to be able to select a row and have the information from that row update the corresponding cells on the second spread sheet, is this possible??? please help!! Thank you!