Upgrade Operating System Snow Leopard to OS Sierra I know I must upgrade first to El Capitan before upgrading to OS Sierra.
But my question is will I loose installed Adobe Photoshop CS5 and my Bootcamp where I have 2 other costly programmmes installed.
Doubtful that you'll lose either Photoshop on the Mac partition or the Bootcamp partition itself while upgrading. Of course, backing up before moving forward is always the way to go.  :)