A big Thank You to XLD for providing the link, but I could only go as far as doing the browse and zip example. Which, like i said, is incredibly helpful, but I don't know how to make it automatically zip up files that are linked in the excel file.

I've attached what I did, but it probably won't help. Sorry.