I am new to the advance functions of Excel.

I have an inventory sheet running. I want to place a check box next to each line and once the box is checked, it copies the 3 or 4 different columns in that one row(i.e.: SKU#, Description, Manaufactor and Current Quantity) to another sheet and prompts you to enter the amount to order. As I check different items, I want it to place that information on the next line generating a running order list. I have about 400 items in my inventory and just want to go through it and just check off what I need to order. Hope this makes sense.

Thanks