Is it possible to create something in Excel that will take information on one
row and move that information to another row on another sheet in the same
workbook?

I have a workbook for sales leads that I would like to have the option to
move a dead lead off the active sheet onto a completely different sheet. It
would clear the row of the now dead lead and continue to the list on the
other sheet as more and more leads become inactive.

Is that even possible?