Black/gray screen; Been told CCD needs to be replaced; where?

Richard Byrne, that depends on where you live. I would suggest that you Google for a camera repair service close to your geographic region. ifixit does not do repairs, here you get plenty of free advice to help you fix your camera. Or, and that is even a better idea, download the service manual from here. It has all the steps you need listed. Then you can try and repair it yourself. Hope this helps, good luck.