Automatically add sheets to master document

[Mearsy]

I'm not quite sure where to post this request, but hoping someone will pick this up and help.

I have a Master sheet that (hopefully) will have a macro behind it that when run will open a different sheet (probably in the same file) take a copy of it, add it to the back of the Master document and then close the original sheet. I've attached an example of the Master document and a Spec document, what I would like to end up with is an automated way of adding a copy of the Spec document to the Master document.
I did try to "record" a macro to do this, it recorded ok but then wouldn't run correctly.

I have no idea of where to start with this.

I hope I've been clear and that someone much clever than myself can help.

Thanks in advance.