Changing all formulas in sheet

Hi,

Would it be possible to change all the formulas in a spreadsheet when changing a cell from the drop down list.

For example, I have a formula that copy data from another spreadsheet for one person on the drop-down list, but when I choose another person from the drop down list I want the formulas to change. Is this possible to do?