Create worksheets copies based on Textbox value

hi everyone,

So I've found a way to create copies of worksheet1 based on a numerical value entered by the user. The following is my code:

Please Login or Register  to view this content.

The tough part:

I have two worksheets in the workbook: Sheet1 and Signoff.
Sheet1 is copying the way it should based on the code above, however the copied worksheets are beingplaced after the Signoff worksheet (to the right of it).

How can i amend the code I have to direct the copied worksheets to be placed to the right of Sheet1 and to the left of Signoff rather than to the right of Signoff?

Thanks!!