Looking for formula.

hi looking for a formula to combine two worksheets in one both have 3 columns.
if i copy the both worksheet in one than i have 6 columns like this.

A ---------B --------C----------- D -----------E--------------F------------G
ireland----353-------0.34 ------1.66----------india--------- 92---------3.67
germany--12--------2.33 -------2.78---------USA-----------01--------- 0.75
india-------92-------1.23-----------------------UK------------44----------1.98
usa-------- 1 -------0.25-----------------------GERMANY-----12----------2.78 (delete)
uk ---------44-------3.23----------------------ireland---------353---------1.66 (delete)

FORMULA: It should match the two value in columns A (ireland) & B(353) with values in column E(ireland) & F(353)........than write the value of G(0.75) in Column D in front of IRELANF in column A......and delete the value 1.66 from G column.