I don't get it... - Merging

[PurchaseGuy]

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!

 

[Otto Moehrbach]

In the 2009 Sales sheet you have the salesmen's names in both Column 1 and
Column 2. Is that what you want? Regarding auto-update, when do you want
this auto-update to take place? HTH Otto

 

[PurchaseGuy]

No sorry.. That was just my attempt to show how the list would look once
merged. The only actual information in a cell is either the sales order # or
the Customer Name. Each of the sales staff have their own six digit sales
order account (100001,123000, etc.) and I want the sales to be listed in
lowest to highest order number so that I can do a vlookup.

Updating needs to be at least once a day, preferable 2-4 times a day.

Thanks!