Yes,

Create your invoice page in say sheet 1.

Then if your data is in sheet 2 and row 1 use the indirect function e.g


=INDIRECT("SHEET2!A"&A1)

A1 is the line in sheet 2 you want to invoice "SHEET2!A" is the sheet
name you want to indirectly look up and the A is the colun you want to
look up

Also you would have a contact sheet which you would look at the
customer address with a indirect vlookup.

The trick is to have a control box for the

Name of company or person to lookup
Name of Sheet (If referencing more than one).
Row Number


I've attached the link which might help on the indirect front.

http://www.j-walk.com/ss/excel/usertips/tip015.htm

VBA noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561345