Changing all formulas in a sheet

[Himesh1]

Hi, would it be possible to change all the formulas in the spreadsheet when changing the content of one cell that is a drop down menu. The formulas are also linked to another spreadsheet.

For example in the spreadsheet attached, the Team member is a drop down list and formulas would be in the date last completed, which is copied from sheet 2. Therefore, when I choose a different team member I want the dates to update automatically.

How can this be done?

Thanks