How to automate moving specific info from one spreadsheet to another

Create a macro then link a button to that macro.
from the Tools drop down select Macros, then select Record new macro, give the macro a name.
Then go thru the motions of selecting, copying and pasteing the data, when thru, go back to Tools, macros and stop recording.
Create a button and link the macro to that button

Thanks, do you know if there is a way I could change the Sheet names it saves to each month. Such as one month is Dec Statements the next month would be Jan.