This is a problem I have that I thought was near to impossible. I have a nightmare test case for you. I am a property manager of 1000 units. We have 40 properties each of which we track vacancies with a spreadsheet. They've got all relative property data on them as well. Let me know if you are interested.
My solution was to build a web app for this completely out of spreadsheet land. But I've got some other things to tackle first. Either way good luck!