Copiyng From one sheet to the other (excel)

Hi everyone,

I have a issue:

In SheetA I have:

Cell A1 = bla bla
Cell F2 = bla bla
Cell G3 = bla bla

Is there any code that can help me to bring the contents of these cells and copy them to

Sheet B

A1 = Sheet cell 1A
B1 = Sheet cell F2
C1 = Sheet cell G3. Because on sheet A this cells will be refreshed cotiniously so I was trynig to insert a commandclick nammed save that every time the user click on the command cotton the contents of these cells should be added on the next sheet in a row and the next time the contents of sheet a should be added again in sheet B but on the next row and so on.

Resume: In sheet a I have: |John | Frederick| class 1b| this should be copied on the second row of sheet b then when I click on the command botton next time will have
|Maurice| Antonius | class 5d| and so on so sheet 2 will be creating lika a sort of list with multiple rows.

Please if anyone can help me I will higly apreciate it .

Thanks Regards

Theo