Combine two spread sheets into one - select data only

[mlbarry]

Spread sheet # 1 DATA SHEET

Customer #

Customer PO

Customer Name

Invoice #

Invoice Date

Due Date

Phone

Amount Invoiced

Amount Paid / Credited

Days Past Due

Amount Due

<tbody>
</tbody>

Spread sheet # 2 Sheet with info to use

Customer #

Customer PO

Customer Name

<tbody>
</tbody>

Spread sheet # 3 Gathe information from Sheet 1 & 2

Customer #

Customer PO

Customer Name

Invoice #

Invoice Date

Due Date

Phone

Amount Invoiced

Amount Paid / Credited

Days Past Due

Amount Due

<tbody>
</tbody>

The data sheet (# 1) has a list of all customers with their data (i.e. 001,002,003,004,005,006 etc) I have a select list of cutomers on # 2 (i.e. Customer # - 002, 004 005 etc) and I want to only show the selected data on # 3 but each cutomer number may have from 0 to 500 invoices and I do not want a total I want all invoices to show. I need the formula to look at sheet 2 and go to sheet 1 for the information and place it on sheet 3. The invoice number is the unique number on the data (sheet 1) sheets. Assume the Customer is Column 1 and the data starts at Row 2