excl vba API

We use excel worksheets on desktop to produce job sheets. We need to copy some lines of data from each excel file and add to cloud based software Clickup using API and VBA. Several different users will be able to add the information to the one cloud platform. I envisage the data would be uploaded by clicking a button on the completed job sheet which would use VBA to transfer the data to the cloud.