Save in PDF a excel sheet

Dear all,

I am a brand new user on the forum, thus HELLO everyone !

I encountered an issue to create a macro allowing to save a excel sheet 2007 in PDF format.

Particularity of my sheet "Site PROFILE :
In the cell B5 of "Site PROFILE" I have to type a code which allow to consult the results of each code ("sheet1").
To sum up I have only one sheet "Site PROFILE" for several results.

Request
I tried to create a macro which type every code containing in the "sheet1" and save each code in my DOCUMENTS folder for instance, but Its not working at all...So, someone could kindly help me?

Many thanks for your help and advice in order to help me to build my Macro "Module 8" in the file attached.

Kind regards,