Linking smartsheets - Dropdown menu change

I have a current spreadsheet and one of the cells is a drop down menu for status. When I change the status to a certain one I want the smartsheet to be linked to another sheet and it will pull certain pieces of information from the same row on the original smartsheet into the new smartsheet.

Answers