I have a Names worksheet with bunch of rows with names and addresses in columns. In this worksheet rows gets added and deleted all the time.

On a second worksheet (lets call it Labels) I want to make two columns combining some of the cells in Names worksheet to make something like address labels.

For instance, Labels!A1 will have the address that is on row 1 in Names worksheet. Labels!B1 will have the address that is on row 2 in the Names worksheet. Labels!A2 will have the address that is on row 3 in the Names worksheet and Labels!B2 will have the address that is in row 4 in the Names worksheet etc.

How do I reference the Names worksheet cells in the Labels worksheet so that I don't get reference errors when rows gets added or deleted in the Names worksheet?