Interesting use case

Hi,

I would like to use Zoho Sheets to show the calculations needed on the following page (the page is about micro financing to reduce poverty) and others like it:
http://myc4.com/Portal/WebForms/Opportunities/ViewOpportunity.aspx?OpportunityId=3656&activeView=uiLoanFinancialsView

I was able to link the data form the page into Zoho Sheet. The results can be seen on:
http://public.sheet.zoho.com/public/hulagutten/linking-test

My problem is that there are more than 150 pages like the one shown above, and more coming every day. I therefore need to make the linked url dynamic.

Is this possible. Maybe through the API or other means?

Regards,

David
hulagutten