Advanced Filtered AND/OR Criteria

On Sheet1, I have 3 columns A,B and C, only the column headings stay, the data change regularly.

DateA1
5/10/07
6/5/07
7/1/07

NameB1
NY
CA
TX

DateC1
7/10/07
7/12/07
8/1/07

On sheet 2, I have an advanced filtered data table,
cell E1=30, E2 =40, E3=50

I have AND/OR Criteria

COLUMN-A
NameB1
NY
CA
TX

COLUMN-B
DateC1
=">"&('Sheet1'!A2+$E$1)
=">"&('Sheet1'!A2+$E$2)
=">"&('Sheet1'!A2+$E$3)

I want to say:
filter all NY orders if date in C(sheet1) is more 30 days (E1) from date in A(sheet1)

filter all CA orders if date in C(sheet1) is more 40 days (E2) from date in A(sheet1)

filter all TX orders if date in C(sheet1) is more 30 days (E3) from date in A(sheet1)
===========================

All the data pulled and lay out the way I want it, except the date comparison is WRONG,

I want it to filter IF

DateC > (DateA + 30days)

The PROBLEM I have is, DateC moves from cell C2 to C3, to C4...
But DateA2 stay the same as A2

For example, in row 5, it compares DateC5 to DateA2+30
(when I want DateC5 compares to DateA5+30)


=">"&('Sheet1'!A2+$E$1)
for A2 above, I try with and without absolute value $A$2 but it still doesn't work