I want to do 2000 lines of data coming from another worksheet. To get the
first cell of information I want the formula is

cell A2 formula
=IF('[Customer Information.xls]A'!$E$6 ="","",'[Customer
Information.xls]A'!$E$6)

cell A3 formula
=IF('[Customer Information.xls]A'!$E$13 ="","",'[Customer
Information.xls]A'!$E$13)

cell A4 formula
=IF('[Customer Information.xls]A'!$E$20 ="","",'[Customer
Information.xls]A'!$E$20)

I have tried the "fill-in method" where I took out the $ so the formulas read

cell A2 formula
=IF('[Customer Information.xls]A'!$E6 ="","",'[Customer
Information.xls]A'!$E6)

cell A3 formula
=IF('[Customer Information.xls]A'!$E13 ="","",'[Customer
Information.xls]A'!$E13)

cell A4 formula
=IF('[Customer Information.xls]A'!$E20 ="","",'[Customer
Information.xls]A'!$E20)

I hoped the formula for A5 would be

=IF('[Customer Information.xls]A'!$E27 ="","",'[Customer
Information.xls]A'!$E27)

Unfortunately it was:
=IF('[Customer Information.xls]A'!$E9 ="","",'[Customer
Information.xls]A'!$E9)

What am I doing wrong? Is there a way to make this increment the way I want
it to?

Thanks for your help.