Generate separate sheet in same work book by selecting certain cells?

Hello hatbox
There may be few options, one is to run a makro to insert a command button in column K, for all the rows that you have. Something like

Please Login or Register  to view this content.

Then you will need to add code for each button to copy row contents to where they are needed. The button number should be aligned to row number so you can increment that.

That said, it may be neater and more suitable to keep your worksheet tidy and write a makro that is assigned to a shortcut key, so when you are in the row to be copied, you can active it with the shortcut and it will copy the row values. Not sure if you want to copy the entire row of values or just everything up to column J.
Something like

Please Login or Register  to view this content.

and paste to sheet you need and location in the sheet

Regards