Matching 2 cells and copying row contents.

Ok here is my query,

I'm running keyword analysis's for client and this requires a search of ranks and search volumns, the problem is these come seperate, so I need a fomular that will link the 2.

So saying you have as an example

Sheet 1

A1 B1
Keyword Rank
Snowsuit 1

Sheet 2
A1 B1 C1
Keyword Competition Monthly Searches
SnowSuit 0.93 3600



I want these 2 to be combined into 1 to save me matching a few tousand keywords manually.

My result I would like is

Sheet 3
A1 B1 C1 D1
Keyword Rank Competition Monthly Searches
SnowSuit 1 0.93 3600


I need to this to run for each individual Keyword.


Is this possible?