access vba excel - Excel

Is there any easy way of writing a formula in a cell that is linked to a number of other spreadsheets so that when changes are made to the data in that reference cell (because information affecting that cell changes) these changes are only reflected in the worksheets with a date on or after the date the changes are made? (i.e. not worksheets with a date prior to the date the changes are made)