I am looking to make a 4x4 Table on a WS. It would look as followed

AUDIT TYPE: Compliance Program Performance/Field
LAST COMPLETED: *Variable1 *Variable2 *Variable3
NEXT DUE: Variable1 + 3 years Variable2 + 1 year Variable3 + 1 year

Where *Variable1 = The most recent date from all WS (except "Sheet1", "Sheet2", "Sheet3) which is found in cell F5 of all other sheets and where cell F3 = "Compliance"
Where *Variable2 = The most recent date from all WS (except "Sheet1", "Sheet2", "Sheet3) which is found in cell F5 of all other sheets and where cell F3 = "Program"
Where *Variable3 = The most recent date from all WS (except "Sheet1", "Sheet2", "Sheet3) which is found in cell F5 of all other sheets and where cell F3 = "Performance/Field"

If *Variable1,2, or 3 are "" or do not provide a date then add then the "NEXT DUE" should equal the date plus the appropriate adjustments provided by the table above.