Leonard Nimoy (March 26, 1931-February 27, 2015) was an American actor. He was best known for his iconic portrayal of the half-Vulcan Spock in the Star Trek movies and television series. Sheldon is obsessed with Nimoy as a result of his obsession with Spock.
He died on February 27th, 2015 at the age of 83 due to complications from COPD (chronic obstructive pulmonary disease). Sheldon's restraining order is no longer in effect.
In "The Bath Item Gift Hypothesis" (S02E11), Penny presented Sheldon with a napkin signed by Leonard Nimoy when she saw him in the Cheesecake Factory. Sheldon was overjoyed to receiving the napkin as a Christmas gift from Penny, and overwhelmed on learning the napkin contained Nimoy's DNA. Sheldon briefly mulled the notion of cloning Nimoy, but Penny declined Sheldon's implicit request for a "healthy ovum". The episode concludes with a Saturnalia miracle, a never-seen-before "Sheldon Hug".
In "The Excelsior Acquisition" (S03E16), Sheldon revealed that he had a restraining order from Leonard Nimoy after receiving a restraining order from Stan Lee. He unfortunately died on the 27th of February 2015, live long and prosper, a life well lived. Whether or not his death will be mentioned on the show (and the guys reaction to it, especially Sheldon's), is unknown.
In "The Transporter Malfunction" (S05E20), Nimoy voice acts for a Spock action-figure who convinces Sheldon to use his transporter, and then shuns him for replacing it with Leonard's after he broke his own.