Multiple sheets to single pdf saved with cell reference

Hi,

I have looked everywhere on this forum but cannot find it.

I am looking for a vba code where it will select sheet1,2,3,4&5 and convert them into a single PDF document using the excel print areas properties and also automatically saving it on the user's desktop as this is a shared document.

What I am also looking is it automatically saved using the reference in cell A3 (doesn't matter which sheet as all A3 in all the sheets has the same formula)

Many Thanks

PS as everybody else am new to VBA

Thanks

This works great exactly what i need thanks