I need to merge unique values from multiple sheets in one excel file in such
as way that the end result is a list in number order on the merge sheet.

I want to be able to expand it in the future, though currently I have 4
sales people.

A.K.A. - Merge
2009 Sales.xls
Tab 1 = Saleman #1
Column 1:
Order #
10001
10002

Column 2:
Customer:
Customer Name
Customer Name

Tab 2 = Saleman #2
Column 1:
Order #
20001
20002

Column 2:
Customer:
Customer Name
Customer Name

Etc.

into an existing workbook in a 2009 Sales sheet:

Column1:
Salesman #1 Order 1
Salesman #1 Order 2
Salesman #1 Order 3
Salesman #2 Order 1
Salesman #2 Order 2
Salesman #2 Order 3

Column2:
Salesman #1 Customer Name
Salesman #1 Customer Name
Salesman #1 Customer Name
Salesman #2 Customer Name
etc.
The list needs to grow as we make sales so that current customer information
is available. Auto update is a plus.

I just don't get this VBA thing and don't have money to hire someone.

Please Help!