Excel comparison of partial or wild card data

Hello,

I have two columns in Excel that I want to compare. The data in work sheet 1, column A has values that are tabbed. This data has the adjacent descriptions in the same work sheet column B, that I would like to keep connected.

There is another work sheet 2 that has the same values as mentioned above that have been wild carded by removing the duplicate tabs from a prior program. Lets call it column B of worksheet 2.

I would like to compare values in column A work sheet 1 with the values in column B worksheet 2 that are truncated and replaced with wild card value. I would like the values to be sorted and placed in a different column along with its description that is attached to the first set of data in worksheet 1.

So it looks like this.

Worksheet 1 Column A Column B
m00012345-1 description of A1
5678-01 description of A2
5678-02 description of A3
(other data)


Worksheet 2 Column B
m00012345*
m00089898*
5678*
(other wild card data)

I would like to sort the data to produce one column of tabbed data with its description in worksheet 2 any column.

Thanks for your time.
I appreciate your help on this?