Is there value to taking multivitamins?

I’ve heard it is good to take vitamins, and I’ve heard you just pee them out without your system absorbing the nutrients. I used to take a multivitamin and fish oil all the time, but I’ve stopped since I realized I don’t know if it a useless thing to do. Anyone know the truth on this one? Please give me a source to back it up if possible.