Is this possible?

Active Workbook = the open workbook (variable document name)
Active Worksheet = Data Entry
Surveyed Buildings = a worksheet within a closed workbook (2009 Surveys) a
different folder

Activeworksheet("A2") = building #
Activeworksheet("B2") = survey date
Activeworksheet("C2") = next scheduled survey cycle (1 year, 2 year, 3 year)

Surveyed Buildings("R:R") = building #
Surveyed Buildings("S:S") = survey date
Surveyed Buildings("T:T") = next scheduled survey cycle
Surveyed Buildings("U:U") = next scheduled survey

If Activeworksheet ("A2") matches a building number in Surveyed Buildings
("R:R"), place values from Activeworksheet(B2, C2) in corresponding cells of
Surveyed Buildings: otherwise place the data on a new row

Calculate the Surveyed Buildings next survey date: survey date(S:S) + 1
year, 2 year, or 3 year

Also! If the next scheduled survey date is calculated on the
Activeworksheet, can the data be sent to Outlook (on the calendar or a new
task?)