Dream Big: Finding the Courage to Follow Your Dreams and Laugh at Your Nightmares by Lisa Hammond is a great one. Her story is about starting a business but the message can apply to anyone and anything.
Letters to A Young Poet by Rainer Marie Rilke is one on my to-read list, Whoopie Goldberg mentions it in Sister Act 2.
SARK is another great author to check out...I think it all started with a book called Succulent Wild Woman but when I pulled up Dream Big on Amazon to get the author's name I saw a few other SARK titles and one especially jumped out: Make Your Creative Dreams Real: A Plan for Procrastinators, Perfectionists, Busy People, and People Who Would Really Rather Sleep All Day