Extract data after choose data from excel dropdown list in Excel

I have a table in Excel. Everytime I choose value in the dropdown list, other row data will calculate the data base on pre-set formula. Is there a way I can extract all the data I want for every value I choose in the droplist to another sheet.