If you would like a database to automatically update when you update your spreadsheet, you should link them. Links between them are needed so that values entered in one can be used in another. Linked data is only updated when the files are opened, unless you specifically click Data | Connections | Edit Links | Update Values.
