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%