I have a list of names and their assorted properties.

I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it.

Currently I can accomplish this by copy and pasting the entire row, but this is not elegant nor dynamic (the number in blue does *not* update with this method):

My ideal solution: A name is typed into the "Name" column. The spreadsheet program pulls the associated row from the "main" sheet into the new sheet.

I am currently using Numbers.app, but am curious if this is possible in Excel, OpenOffice Calc, Google Docs, or any other spreadsheet program. Thank you.