Could anybody please help.

I have wrote code to insert a pdf file into my worksheet as an attachment......and not so much link, however place it in a cell and resize it.
I have also wrote code to save my excel file as a pdf file.
However, is it possible to have code produce the following as I am struggling to put the 2 together and a little more besides: -

On the click of a button, save the current excel sheet I am working on as a pdf file, open up another workbook and copy or transfer this newly created pdf file into this workbook.
So not so much after transferring/copying individual cells of data, more want to transfer/copy the whole excel file into a new workbook as a pdf attachement.

Hope this makes some sort of sense.

Kind Regards
Steve