Any advice here is going to be very limited if we don't get to see your workbook.

Suppose Sheet1 has account numbers in column A and balance in column B.

Sheet2 has account numbers in column A, addresses in column B, and other pertinent information in other pertinent rows.

I assume there is a header row in each sheet.

In Sheet1!C2, use this formula to get the address, and copy down:

=VLOOKUP(A2,Sheet2!A:B,2,FALSE)

For the next column:

=VLOOKUP(A2,Sheet2!A:C,3,FALSE)

For each succeeding column to populate, modify the formula by increasing the width of the range and adding 1 to the number.