click to run, print current page then copy and past cells in to next avalable space.

Hello world

Im new to excel and VBA and was wondering if any one can help me to write a macro to firstly print sheet and then copy 7 indavidual cells on one work sheet with out disrupting the sheet and entering that infomation on to the second sheet in to the next avaliable row once it has done that i would like it to clear the content of the indavidual boxes

I dont know if its posible but your help would be most greatful.