Copy/paste macro help request

Hello All!

I'm new to Excel advanced features (i.e. macros). I've searched Google all day and have not come up with a

macro that accomplishes what I need in total.

I need command button macro that will:
Copy cells M14:Q14 on Sheet1
Paste the value of the copied cells on the first empty row of column A on Sheet 2
Paste the value of same copied cells (transposed) in the first empty cell of row 3 on Sheet3 Clear the values

(but not the validation) of cells I13:I17 on Sheet 1

Many thanks for your help!
Deb

Jerry,

Thanks for the quick turnaround! I tried the code you posted....unfortunately, it only pasted the first cell of the (5) cell range on Sheet 2 (and nothing pasted to Sheet 3). What am I missing?

Thanks! Deb