Data base working with multiple spreadsheets

[DAND]

Here is my question, I thought it would be a simple thing but I am having very hard time with this.

I have 5 spreadsheets and counting, all same headers

1. I would like to create a database that pulls the data from all sheets into one place.
2. I would like to be able to edit data in either a single sheet or the Database and have it reflect in the other.
3. be able to rearrange and organize the data in the database.
4. have the spreadsheets stored on my google cloud (excel format) along with the database.
5. have the changed saved in real-time, if possible.

Thanks
Dan

[frofa]

There re a lot of different elements in your question/s, Dan (in fact an entire project!). Combining all your spreadsheets into one does sound like a good idea (at first glance, without knowing anything about your data).

My general opinion would be that you should use either a spreadsheet OR a true database, not both. (Don’t add a layer of complexity if it is not needed.) Generally, many applications only need one ‘flat’ style database - i.e. a simple LIST, without any additional key-fields showing interlinking between multiple separate lists, so a spreadsheet (Calc sheet) can be used as your database. If you have more complex needs and want to query multiple interlinked data-tables, then use Base for your database.

Also, ask yourself the question what information do I need to get from my data? (i.e. the queries required). Finally, I would suggest posting separate questions for each step of your project (if you need to).