Lookup Help Complicated

[Gizmo]

Excel2003
How can I do this? It's a little complex.

First:
Copy values from sheet1.
("A1"-Date,"B2"-Name,"C5"-Temperature1,"D8"-Temperature2,"E11"-Temperature3,"F4"-Chamber)

Second:
Then, depending on 1 value (F4-Chamber. 6 possible values, a thru f),
Move to another sheet (2,3 or 4).
(ex: If F4-Chamber="a" or "b" Move to sheet 2, If F4-Chamber="c" or "d" Move
to sheet 3, If F4-Chamber="e" or "f" Move to sheet4)

Third:
Then, check the Date Column(A:A) in destination sheet to see if the Date
copied from sheet1 exists.

If Date DOES exist, Then, Paste the values copied from sheet1 into that row
dependant on F4-Chamber value.
(ex: If F4-Chamber="a", Paste
B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2,
FoundDateRow, B,C,D,E.)
or
(If F4-Chamber="b", Paste
B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2
FoundDateRow, F,G,H,I)

Similar if moved to sheet 3 (if F4-Chamber="c" or "d")
Similar if moved to sheet 4 (if F4-Chamber="e" or "f")

If Date DOESN'T exist, Paste values to Newrow.
(ex: If F4-Chamber="a", Paste
A1-Date,B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 TO Sheet2,
Newrow, A,B,C,D,E.)
or
(If F4-Chamber="b", paste
A1-Date,B2-Name,C5-Temperature1,D8-Temperature2,E11-Temperature3 to Sheet2,
Newrow, A,F,G,H,I)

Similar if moved to sheet 3 (if F4-Chamber="c" or "d")
Similar if moved to sheet 4 (if F4-Chamber="e" or "f")

Hope this makes sense

 

[Gizmo]

Sorry, Another wrinkle.

After finding date, check to see if dependent paste range has data. if so
add new row and paste data.
Ex:
If Date DOES exist, Then,
If F4-Chamber="a" Check Sheet2, FoundDateRow, B,C,D,E. If Empty, Paste
B2,C5,D8,E11. If Not Empty, Paste A1,B2,C5,D8,E11 to Newrow.
Or
If F4-Chamber="b" Check Sheet2, FoundDateRow, F,G,H,I. If empty, Paste
B2,C5,D8,E11. If Not empty, Paste A1,B2,C5,D8,E11 to new row.