Creating Data Sets From Master Sheet?

First of all I'll state that I'm a total excel novice and have very limited technical knowledge of the program as well as advanced macros. Second, my problem is kind of complex so forgive my explanation if it's confusing.
Now, I fear my desired end result may not even be possible with excel... if not, I'd like to hear it from you guys... If so, please help me in getting what I need out of the data I'm working with...

okay, I start out with two seperate spreadsheets, one is a large database with about 10-12 columns and we'll say 400 rows. The other is database with around 6-7 columns and slightly (usually about 15%) fewer rows. We'll call these spreadsheets A and B respectively. They both contain data within some of their columns and rows that matches. A has data which needs to go with data on B and vice versa. I need the rows on A which match up with the rows on B to be paired up so I can have the unmatching data from some columns on 1 speadsheet... My company has tagged the actual data I'm working with as sensative, so I can't post it here... Instead i've included what I hope is a simplified example... This example shows the two speadsheets I'm working with (A & B) and the spreadsheet I need, which I'll call X. I don't know how to do formatted text or insert table in here... so I made some cruddy looking text ones in here.
Please help out if possible.


A
FRUIT QUANTITY WEIGHT LOCATION NEED
APPLE 3 2.1 CA 99.00%
ORANGE 5 1.9 FL 23.00%
BANANA 2 2.3 FL 55.00%
APPLE 2 2.4 MN 27.00%
GRAPE 2 0.55 CA 68.00%

B
FRUIT QUANTITY WEIGHT LOCATION COST
APPLE 3 2.1 CA $2.80
ORANGE 5 1.9 FL $1.05
BANANA 2 2.3 FL $3.50
GRAPE 2 0.55 CA $3.28


X
FRUIT QUANTITY WEIGHT LOCATION COST NEED
APPLE 3 2.1 CA $2.80 99.00%
ORANGE 5 1.9 FL $1.05 23.00%
BANANA 2 2.3 FL $3.50 55.00%
GRAPE 2 0.55 CA $3.28 68.00%

Okay, I've managed to come up with a slightly better example sheet for you guys to check out... you'll see on here that sheets A and B share some data, though this data may or may not be represented slightly differently. What I ultimately want is a sheet like sheet X which has been sorted by to key sets of data. In the example I've included, the data which must be used to filter is the drivers liscense number and social security number-these are just fabricated examples btw, so don't worry about identity theft . The differences in the way the DL# and SSN are represented should be clear on the sheets: in sheet A DL#'s have additional suffixes at the end of their ten digits (they'll always be ten digits until the suffix btw...); SSN in sheet A is broken into two columns, on sheet B the digits simply have a space between them. Ideally I'd like the process to make what I need to happen explained to me so I can transition whatever you guys come up with over to the real data that I'm working with. So to restate, I need all the info from sheets A & B to be paired up with their respective match; they need to be matched (in this example) by drivers liscense number and social security#... sheet X is a sample of what I want... and please try to break down everything you guys come up with "abc style" for me ... Again, I'm really sorry for my convoluted example... you're help is very very very desperately needed at this point....