Here's a list of famous people with MS
. I'm sure with a little research you could find quite a few inspirational stories among them.
Just a quick search, but I'm sure with a little research you can find what you're looking for.
Tough news for your family, wish you all the best.