Please help me out, how do I use a consolidated drop down list by using
multiple worksheets within a workbook?

Scenario is.
Sheet1 : List of No. of Customers of Div1
Sheet1 : List of No. of Customers of Div2
Sheet1 = List of No. of Customers of Div3
Sheet1 = List No. of Customers of Div4
Sheet1 = List No. of Customers of Div5

I want to get a conlidated drop down list of all customers of all Divisions
to monitor closely the Billed Amount - Payment Received and Payment
Receivable by using Office 2003.

Thanks,
M. Nazim