in reply to Design elegance : How to best design this simple program ?
i have maybe 1000 or 2000 [...] spreadsheets
Not exactly what you asked for, but perhaps you should get rid of spreadsheets and use a RDBMS instead.
Alexander