Setting up data collection using API - Equipment Tracking System

Hi guys,

I am helping a friend of mine (waste/recycling disposal business) to develop an mobile/ipad based system where he can track all his bins. I setup a simple Wufoo form his employees can use, and setup an excel sheet he can paste his data into that tells him the latest on where all his bins are (he has about 120 x 6-10m^3 bins - a lot to track!)

I am a fair novice coder/programmer, but hoping someone can point me in the right direction as to what topics I should look into in order to write the required scripts/code to generate (for example: daily downloads of his data). Wufoo allows for acces through API but they won't provide support in achieving this.

It would be really cool if his data downloaded at the end of every day so he doesn't need to; a) login to wufoo b) go to entries area c) download into xml d) copy and paste into master spreadsheet

If the file was always sitting in his dropbox for example, he could just copy/paste the data in each morning.

Any help is hugely appreciated! I have the bulk worked out, but it isn't quite so user friendly for a garbage man that doesn't use computers much - it could be way better!

Thanks, Ryan