Sorting part numbers in order

I have a list of part numbers and sales figures for them, for Cars. For example:
Jan 2012
100-000-001Car 5
100-000-002Car 6
100-000-003Car 4

I have a list of part numbers and sales figures for them, for Trucks -- and there is a lot of overlap in part numbers. For example:

Jan 2012
100-000-001Truck 5
100-000-003Truck 6

I have a list of part numbers and sales figures for them, for Motorcycles, with a lot of overlap. For example:

Jan 2012
100-000-001Bike 7
100-000-002Bike 4

And I have a list of part numbers and sales figures, for Total.

Jan 2012
100-000-001Total 17
100-000-002Total 10
100-000-003Total 10

Right now I have these figures in separate tabs; I could put them in the same tab if necessary.

I want to put this info in order, like this:

Jan 2012
100-000-001Car 5
100-000-001Truck 5
100-000-001Bike 7
100-000-001Total 17
100-000-002Car 6
100-000-002Bike 4
100-000-002Total 10

etc.

How do I put this all together? I think VLOOKUP will be part of it, and sorting, but I'm confused.

Thanks!

Thank you, Pauley!