This is where basic programming skills can you save you a lot of manual labor. For work I've written scripts to batch zip, batch rename, etc. Recently wrote a script to download ETF holdings around the web and upload to Google Drive, where I have pivot tables setup for analysis. This allows me to know my overall underlying stock exposure.