Code to attach to button to autmatically import a template sheet

Is this possible?
I have a workbook in which I would like to be able to import a new sheet of each month... not sure how to do this.

.
Paste this code into a routine module:

Please Login or Register  to view this content.

Thanks very much. Instead of a selection, can I specify the exact sheet within the code, instead?

Please Login or Register  to view this content.

Awesome!
Last question... what if I always wanted to put the sheet before or after another specific sheet?

Originally Posted by adamgm

Awesome!
Last question... what if I always wanted to put the sheet before or after another specific sheet?

Hi,
This is to put sheet before:

Please Login or Register  to view this content.

and this is for after:

Please Login or Register  to view this content.

Originally Posted by Indi_Ra

Hi,
This is to put sheet before:

Please Login or Register  to view this content.

and this is for after:

Please Login or Register  to view this content.

I was having trouble with the exact syntax, but I get it now, I had to edit within the brackets for the sheet name.

Thanks for the Add Rep