Update All Links to PPT from Excel at one click Using VBA or if having other option

More than 100+ cell values are displayed on the PPT slide. These are not from a single table but different sheets, columns, and rows. I managed to link these to the PPT. but while sharing to another person or moving to another folder location, this one is not working. Even I can't be able to update all links. if "update links" are clicked at the beginning it crashes and it is hard enough to update all the links one by one. is it possible to update all the links at once? or how to handle this situation.