Copy and Paste cells from Range with data

Too many worksheets with SLA in them. I am thoroughly confused about what you want to go where and under what circumstances.

Sorry about the confusion. Ive re uploaded it.
Goto Home and put type test into cell B4 and and hit New Order Command button. This has just created a new worksheet called 'test SLA Order'
(SLA Order is my master sheet)
Goto test SLA ORDER and fill in the first couple of rows from the drop down boxes and enter a quantity in the next cell.
So what I need is for the command button on this worksheet to copy only the cells with anything in them from the green cells above and paste them into the
worksheet Totals.
When a new order is created there may be a different number of cells filled in on the newly created worksheet %%% SLA Order and again I need the command button on this worksheet to copy only the cells with anything in them from the green cells above and paste them into the
worksheet Totals directly below the previously pasted cells.

Is that any better?

Much clearer explanation. If you want the pasted formatting on the Totals sheet to be different from the SLA sheet let me know.

Please Login or Register  to view this content.

Hello
The above code works great but I need it to work if there are occupied cells below the green cells.
ive updated the sample spreadsheet