Attach doc as a new sheet in master document

[Mearsy]

Hoping someone can start me in the right direction with this one please, I thought I had it but......
I have a master document that will have buttons on it that when selected they will automatically open a new document, take a copy of it and add it to the back of the master document. I want to be able to do this with several documents on one master sheet. Hopefully my attachments will make this a little clearer.
Many thanks in anticipation.

[BuckoAk]

Mearsy,

Give this a try.
Some assumptions were made with the import file, it is assumed that the first sheet is to be imported. i.e Spec.xls(Sheet1), Data Sheet.xls(Sheet1) and so on.
With only two specific sheet names given, It is assumed that the imported sheet names are to be the new sheet names in the Master.xls file.

Master RevA.xls

[Mearsy]

Excellent, many thanks.