Invoice address query

Try:

=VLOOKUP($B$8,ADDRESSES!$A$2:$E$100,ROWS($A$1:$A2),FALSE)

this will take Address 1..

When/If you copy the formula down a few cells, it will then, consecutively, take the other address info too.