Move a range of cells to another sheet

Hello,

I've done a bunch of searching around and it looks like a lot of folks have a similar questions about this however I haven't seen anyone ask exactly what i'm after...hoping someone can help.

I have within one workbook two worksheets...It is basically a sales tracker and when I mark a row "CLOSED" using a drop down list I want that range of cells say C5:O5 to either copy or move (don't really care either way) to the other worksheet called "Closed Business". On top of that, I would love for it to move or copy that info to the first open space as there may already be data in that sheet and I don't want it to copy over it.

Also, I don't necessarily want to just move the whole row because there are columns that contain data i don't want moved over...just the range I mentioned above as an example.

Hope this makes sense! I can reply back with additional details or the actual file if needed! Thanks for the help everyone!

Evan