We are a healthcare products and services company, we create a bridge between physicians/physicians groups and vendors for lab, pharmacy, surgical screws, etc and provide them with the best price.  This requires working with multiple vendors.  The only insight into how many prescriptions for (insert drug name here) were ordered, is for us to go to the vendor portal for that pharmacy and manually pull the data.  The same problem exists for the other vendors.   So again,  in order to find out how many products/services were ordered by our customers (from our vendors) we need to log into the vendor portals and extract the data manually through a CSV export, and then combine lists (most customers utilize most or all services which means they order from most or all of our vendors).   It’s a pain, so we are looking to automate that. Any help would be appreciated.