Consolidate data from two sheets into one

[geomit]

Hi guys, I woulb be very grateful if you could help me with my problem.

In the first sheet i have these data

Time______Station______Power
1/1/11 0:00____1__________5
1/1/11 0:00____2_________40
1/1/11 0:10____1_________45
1/1/11 0:10____2_________50
1/1/11 0:10____3_________51
1/1/11 0:20____1_________15
1/1/11 0:20____2_________20
1/1/11 0:20____3_________34
1/1/11 0:20____4_________33
1/1/11 0:30____1_________10
1/1/11 0:30____3__________9

In the second sheet

Time______Station ______air______Pos
1/1/11 0:00____1________2,2______61
1/1/11 0:10____2________1,1______23
1/1/11 0:20____4________2,3_______1
1/1/11 0:30____3________2________49
1/1/11 0:40____3________1,3______11

What i want is to consolidate the data of these two sheets into one that will look like these

Time______Station ______Power______air______Pos
1/1/11 0:00____1___________5________2,2______61
1/1/11 0:00____2__________40
1/1/11 0:00____3
1/1/11 0:00____4
1/1/11 0:10____1__________45
1/1/11 0:10____2__________50________1,1______23
1/1/11 0:10____3__________51
1/1/11 0:10____4
1/1/11 0:20____1__________15
1/1/11 0:20____2__________20
1/1/11 0:20____3__________34
1/1/11 0:20____4__________33________2,3______1
1/1/11 0:30____1__________10
1/1/11 0:30____2
1/1/11 0:30____3___________9________2______49
1/1/11 0:30____4
1/1/11 0:40____1
1/1/11 0:40____2
1/1/11 0:40____3____________________1,3______11
1/1/11 0:40____4

Thank in advance.

[Special-K]

This is an ARRAY FORMULA do not press ENTER use CTRL-SHIFT-ENTER

Try

In sheet 1 column D
=INDEX(Sheet2!$A$1:$D$5,MATCH(A1,IF(B1=Sheet2!B1:B5,Sheet2!A1:A5,""),0),3)
In sheet 1 column E
=INDEX(Sheet2!$A$1:$D$5,MATCH(A1,IF(B1=Sheet2!B1:B5,Sheet2!A1:A5,""),0),4)

Then paste down columns D and E